Original database is changed

[Guest]

I am a highschool computer teacher. I have Access 2003 data files on cds that
came with our textbooks. I saved the datafiles in a folder on our computers.
We open the data files and backup data base and rename the original database.
We then work with the backup or new saved database. When we add new records
to the copy the original database changes too. This is causing me to have to
recopy the original files from the cds everytime a new class comes in to my
room. How can I keep the original from not changing.

 

[Brian Smith]

I am a highschool computer teacher. I have Access 2003 data files on cds
that
came with our textbooks. I saved the datafiles in a folder on our
computers.
We open the data files and backup data base and rename the original
database.
We then work with the backup or new saved database. When we add new
records
to the copy the original database changes too. This is causing me to have
to
recopy the original files from the cds everytime a new class comes in to
my
room. How can I keep the original from not changing.

By any chance is this setup as a front-end/backend scenario? It might be
possible that when you open the front-end you are connecting to the original
backend and that is why it is changing. Do you have the backup files in a
different directory? If not, I'd check out what I mentioned or make sure you
aren't connecting to the original backend by mistake.

Brian

 

[Guest]

By any chance is this setup as a front-end/backend scenario? It might be
possible that when you open the front-end you are connecting to the original
backend and that is why it is changing. Do you have the backup files in a
different directory? If not, I'd check out what I mentioned or make sure you
aren't connecting to the original backend by mistake.

Brian

How do I make sure that I am not connecting to the original? Are there steps I can take. Yes, both the original and the backup copy are located in the same directory "F". Should I put the original database in directory "C" and the copy in "F"?

 

[Todos Menos [MSFT]]

if MDB is too complex for you; then you should move to Access Data
Projects

-Todos

 

[Brian Smith]

I assume by directory C you mean drive C. I would put the files into
separate folders but you don't indicate if you have a frontend/backend
setup. Is your data stored in a separate file from the user interface? If
this is what you have you should be prompted to connect to the backend if
you move the backend file to another location. If so, make sure you connect
to the right backup file (not your original one). If you can give us a bit
more detail we can probably tell you what is happening.

Brian

 

[Tony Toews [MVP]]

if MDB is too complex for you; then you should move to Access Data
Projects

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm