error on opening database after copying to new PC

C

Cynth

I have copied a small database (created by someone else), from a laptop to
another PC. When I try to open it,an error message appears saying that it
cannot find another .mdb file. I still get the error message even when I have
copied the specified file over as well. I have checked the path of the other
access file and it looks okay. As the database was designed by someone else I
do not know why the first database requires the second. What I need to know
is how I could find out what the connection between the two databases is and
why it might be producing this error message.
 
S

Steve Schapel

Cynth

It is usual for an Access application to involve two files, sometimes
referred to as the backend and frontend, with the frontend application
file linking to the core data tables in the backend file. In the file
you have copied, if you look at the database window and select the
Tables tab, do any of the tables show with a little black right-pointing
arrow to the left of the table icon? If so, it probably indicates that
the other .mdb file you are baing asked for is a backend database file.
If you go to the Tools|Database Utilities|Linked Table Manager menu,
you may see a list of the linked tables, which will show you the
location where the frontend application is expecting to find the
backend... I say "may" because the Linked Table Manager is not
installed by default (Grrrr!) Hopefully this will help you get things
set up properly.
 
L

Larry Daugherty

If that is the problem you might solve it by placing both files in a path
that is exactly the same as the path they ran in on the other machine.
Using the Linked Table Manager is the better solution if you have it.

HTH
 
Top