Lost file

R

Richard Luft

Hope that someone can tell me how to find files in
MSOffice. I'm using Windows ME, and I have MS Access 2000
installed in Microsoft Office Directory. In Windows
Explorer, when I look For Access2000 it doesn't seem to
appear anywhere! Thus, of course, I can't seem to find the
databases in my PC to make backups, etc. If I open up the
MSOffice directory, it only shows 'office' and 'templates'
subdirectories, and it's not present in either of these.
The only way I am able to get to Acess2000 is via a
shortcut icon on my desktop.
Anyone have a clue how I can find it?
Richard
 
D

Douglas J. Steele

The executable is msaccess.exe. It should be in the Office subfolder.

One way of knowing where it's located is once you've started it, you can go
to the Immediate window (Ctrl-G), type

?SysCmd(acSysCmdAccessDir)

then hit Enter.
 
T

Tom Wickerath

Thus, of course, I can't seem to find the databases in my PC to make backups, etc.
Click to expand...

so, you probably want to search your hard drive for files with the .MDB file extension. The
default location for all new databases in Access 2000 is shown when you open Access, click on
Tools > Options... and select the General tab. Here, you should see a path defined as "Default
database folder:".

To determine the location of any particular database that you have open in Access 2000 or higher,
you can use the following commands in the Immediate window:

?CurrentDB.Name or ?CurrentProject.FullName for the path + filename
or
?CurrentProject.Path for the path only.


Note: CurrentDB.Name works in Access 97 as well. It will return the 8 character DOS
representation of folder names, such as this:
C:\DOCUME~1\ADMINI~1\MYDOCU~1\Access\......


Tom
_________________________________________________


The executable is msaccess.exe. It should be in the Office subfolder.

One way of knowing where it's located is once you've started it, you can go
to the Immediate window (Ctrl-G), type

?SysCmd(acSysCmdAccessDir)

then hit Enter.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


_________________________________________________



Hope that someone can tell me how to find files in MSOffice. I'm using Windows ME, and I have MS
Access 2000 installed in Microsoft Office Directory. In Windows Explorer, when I look For
Access2000 it doesn't seem to appear anywhere! Thus, of course, I can't seem to find the
databases in my PC to make backups, etc. If I open up the MSOffice directory, it only shows
'office' and 'templates' subdirectories, and it's not present in either of these. The only way I
am able to get to Acess2000 is via a shortcut icon on my desktop. Anyone have a clue how I can
find it?

Richard
 
Top