Where are data and report files?

[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

 

[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

 

[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'

 

[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

 

[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

 

[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.

 

[Joseph Meehan]

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

Note there are both MDB and MDE files. You need one or the other. You
can not edit the design of the MDE file.

 

[Brett]

Note there are both MDB and MDE files. You need one or the other. You
can not edit the design of the MDE file.

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

 

[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