Using "Save As" with Access 2000

[John S. Ford, MD]

Sometimes, while working in Access 2000, I'll want to save a copy of the
file I'm working on as a separate file (with a different name). In other MS
Office products, this is easily done with the File->Save As command.

In Access 2000, such a command only saves a second renamed version of the
actual object that is selected at the time the File->Save As command is
used.

Is there something I'm missing or is there another way of doing this without
leaving Access altogether and copying the file and renaming it?

John

--
-------------------------------------------------------
John S. Ford, MD, MPH
Assistant Professor of Medicine
David Geffen School of Medicine at UCLA
Harbor-UCLA Medical Center
(e-mail address removed)
http://califmedicineman.blogspot.com

 

[Jeff Conrad]

Beginning with Access 2003 there is a command called Backup on the File menu that does exactly that.
I don't think you can do something similar with earlier versions. In 2000 you'll have to exit, copy,
and rename just as you've observed.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:

 

[John S. Ford, MD]

Thanks Jeff. Seems like a weird limitation.

John

 

[John Vinson]

Thanks Jeff. Seems like a weird limitation.

John

The difference is that programs such as Word or Excel are working with
documents. An Access database is not a "document" - it's a CONTAINER
for multiple objects, such as tables, queries, reports, and so on.
Each of these objects can be viewed (in some ways) as being like a
Word document or an Excel workbook.

Making a copy of an entire database should be done for backup purposes
only, as a rule; having the same data in two different databases, and
working with them, is a recipe for trouble, as the two copies will get
out of synch the moment any record in either one is changed.

John W. Vinson[MVP]