Access should allow "Save As" feature like all MS applications

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I downloaded a skeleton Access 2000 file for a computer lab and followed the
professor's instructions to; create a table, set up relationships between
four tables, create a form, create a report, and create an Added Attribute
Query Output.

I have MS Access 2002 (although the class format was Access 2000 and the MS
Access 2002 default is for 2000). When I followed the computer lab
instructions to complete the assignment (noted above), MS Access would not
let me to use the "Save As" feature common to most MS Office applications.
The MS Access "autosave" feature saved my changes to the lab file as a temp
file.

I had to resort to a workaround by creating a blank MS database with the
filename I was required to submit to my professor. With the MS Access Temp
file minimized, I created a blank MS Access database with the filename my
professor required in the computer lab. I saved and closed this blank MS
Access database file. I opened MS Access, clicked on the latest file
accessed, (the most recent temp file with hours worth of work) and began
using the "Export" feature to send Table by table, form by form, query by
query and report by report to this blank MS database.

Why is the "Save As" feature not enabled in MS Access as it is in every
other MS application? MS Access for Dummies 2003 exhorts users to perform
"manual backups" to prevent potential loss of data - how are users suppposed
to do this without a "Save As" feature?

mustang

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9220-3491a240df2f&dg=microsoft.public.access
 
Why is the "Save As" feature not enabled in MS Access as it is in every
other MS application?
Click to expand...

Because an Access database *is not a document*. It's a container for
multiple objects.

If you want to copy pr rename a database, you can use My Computer or
Windows Explorer to copy or rename the .mdb file. The rigamarole of
importing everything into a new database works (and in fact can be
useful if the database becomes corrupted), but it's certainly not
necessary.

John W. Vinson[MVP]
 
[email protected] said:
Why is the "Save As" feature not enabled in MS Access as it is in every
other MS application? MS Access for Dummies 2003 exhorts users to perform
"manual backups" to prevent potential loss of data - how are users
suppposed
to do this without a "Save As" feature?
Click to expand...


It's available in Access 2003. File - Backup Database...
 
Back
Top