Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / January 2008

Tip: Looking for answers? Try searching our database.

Missing Save tab in Tools - Options

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
frustrated_in_VA - 31 Jan 2008 02:04 GMT
Searching for the "Save" tab in Tools-Options in Access 2003, but it isn't
there; only have View, General, Edit/Find, Keyboard, Datasheet, Forms/Report,
Pages, Advanced, INternational, Error Checking, Spelling and Tables/Queries.

Looking for it because I suspec there is something there that will also
allow be to do "Save As" for the MDB.  When I click on File-Save As, I only
get dialog relating to saving an object.

Or are these two seperate problems?  Solutions?
Linq Adams - 31 Jan 2008 02:28 GMT
There is no "Save" Tab Tools - Options in Access 2003

But

File - Back Up Database  

will do what you want.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

frustrated_in_VA - 31 Jan 2008 04:03 GMT
I presume you meant File - Database Utilities - Back Up Database.

I wonder if there is an update to the Help files, which contained this
nugget under "Save a record":

Save files automatically while working

On the Tools menu, click Options, and then click the Save tab.
Select the Save AutoRecover info every check box.
In the minutes box, enter the interval for how often you want to save files.
The more frequently your files are saved, the more information is recovered
if there is a power failure or similar problem while a file is open.

Signature

thanks for your help

> There is no "Save" Tab Tools - Options in Access 2003
>
[quoted text clipped - 3 lines]
>
> will do what you want.
George Nicholson - 31 Jan 2008 23:10 GMT
The "Save a record" Help entry in my installation of Access 2003 SP2 does
not include the incorrect "save files while working"/AutoRecover information
you cite. That would be valid information in Excel, but not Access.

> I wonder if there is an update to the Help files
...are you running SP2 or higher? (Help>About Access)

Signature

HTH,
George

>I presume you meant File - Database Utilities - Back Up Database.
>
[quoted text clipped - 18 lines]
>>
>> will do what you want.
John W. Vinson - 31 Jan 2008 04:54 GMT
>Searching for the "Save" tab in Tools-Options in Access 2003, but it isn't
>there; only have View, General, Edit/Find, Keyboard, Datasheet, Forms/Report,
[quoted text clipped - 5 lines]
>
>Or are these two seperate problems?  Solutions?

Access is unlike Word, Excel or other Office programs in this respect. In Word
you can save (or autosave) the document; but an Access database isn't a
document! It's more like a container for multiple objects (tables, forms,
reports, etc.)

Any of these objects can be individually saved - within the database container
- but the database itself doesn't have a "save" action.

The Help file is misleading in this respect; it's generic Office help here,
not actually applicable to Access.

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.