save as

U

Uncle Larry

I changed my datad base. I wanted to keep the old one and have the new one
also so I went to save as and entered a different name. When I went back to
the old one, it had changed and is now the same as the new one. Is the old
one still somewhere?
 
R

Rick B

Access does not work that way. As you make changes to a database, it is
updated. It's not like Word where you can make a bunch of modifications and
then "commit" them by saving. That's why you don't have to save as you work
in Access
 
J

John Vinson

On Thu, 5 May 2005 13:14:03 -0700, "Uncle Larry" <Uncle
I changed my datad base. I wanted to keep the old one and have the new one
also so I went to save as and entered a different name. When I went back to
the old one, it had changed and is now the same as the new one. Is the old
one still somewhere?

No.

A database IS NOT A DOCUMENT. It's a container for multiple objects.
When you change an object, it's changed right then - there is no
option to "save the database". The "Save As" that you saw does not
refer to the .mdb file, but to the Form or Table or whatever it was
that you were changing - check to see if you have both objects still
in your database.

If you want two .mdb files, one without your changes and one with, the
only way to do so is to make a copy of the .mdb file (preferably using
Windows Explorer with Access *closed*) prior to making the changes.

John W. Vinson[MVP]
 
Top