Where are data and report files?

B

Brett

I need to get all files for a certain MS Access application from one
computer to use on my computer. How do I determine where all associated
data, report, and other files are for the MS Access application so that it
will run on my machine?

Thanks,
Brett
 
R

Rick B

In most cases, all these objects will be in the .mdb file. If you have
linked tables in a front-end/back-end configuration, then you may have two
..mdb files to copy. You may also need the .mdw (workgroup) file if you are
currently asked for a userid and password.

Rick B
 
A

Allen Browne

Just copy the mdb file. All the tables, queries, forms, reports, macros, and
modules are part of that file, so that's all there is to it for a simple
database.

If you have attached tables, you can identify the name of the file they
attach to by opening the Immediate Window (press Ctrl+G), and entering
something like this:
? CurrentDb.TableDefs("Table1").Connect
replacing Table1 with the name of your table.

While you have the Immediate Window open, choose References on the Tools
menu. It is possible that there is a link to another library database there.

It is also possible that some queries contain an IN clause specifying
another database, e.g.:
IN 'c:\SomeFolder\SomeFile.mdb'
 
B

Brett

Thanks. How can I be sure of the MDB file name and location? The MS
Access app is opened, is there a place to find the source file info from
there?

Brett
 
R

Rick B

How did you open it? Did you double-click an icon? If it was a shortcut,
open the properties and look at the source. If it was the actual file, then
that is the file!


Rick B
 
B

Brendan Reynolds

Press Ctrl+G to open the Immediate window, and type

? currentdb.name

and press enter.

The full path/name of the MDB will be printed to the Immediate window.
 
B

Brett

Joseph Meehan said:
Note there are both MDB and MDE files. You need one or the other. You
can not edit the design of the MDE file.
Click to expand...

If I do:

Press Ctrl+G to open the Immediate window, and type

? currentdb.name

and press enter.

and it only returns and MDB file, how can I be sure no MDE files are being
used?

Thanks,
Brett
 
R

Rick B

If you are running the MDB, then that is all you need. An MDE is a limited
copy of the MDB.

Rick B
 
Top