Simply Identifying the location (in My Documents) of the AccessDatabase that I have open

[Dave K]

I am often working in an Access Database, and need to know in which
Folder the Database exists. In other Msft applications, I can find
out by simply selecting file > Save as. But in Access, this is not an
option.

So is there another way to identify in which folder the Access
database is located?

Thanks.

 

[Pete D.]

http://www.mvps.org/access/general/gen0007.htm

 

[Albert D. Kallal]

This kind of begs that question as to how did you manage to open the file
first place and find it?

However in 2003 and later, there is actually a file-backup option in the
file menu, and it is really the same feature that other applications have
for file->save as. (remember in other applications your are with one
document, where as in access you have many little objects such as forms,
reports, queries etc, and the "save as" allows you to operate on each one of
these object.

In addition to the above to "backup" option, you can always hit control G,
and then in the debug window type in

? currentdb.Name

 

[Tom Wickerath]

Hi Albert,

This kind of begs that question as to how did you manage to open the file
first place and find it?

The MRU (Most Recently Used) list, which is maintained in the registry,
especially if one has it set in Tools | Options to maintain the maximum list
size of 9.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________