copying database from one computer to another

[Denise]

Hi, I am trying to copy a large database from one computer to another
location, but when i have done this the files which are located on the new
computer are saying that the "path" is incorrect and the tables, queries
cannot be found. Please advise how i can do this successfully. Many thanks

 

[John W. Vinson]

Hi, I am trying to copy a large database from one computer to another
location, but when i have done this the files which are located on the new
computer are saying that the "path" is incorrect and the tables, queries
cannot be found. Please advise how i can do this successfully. Many thanks

What exactly are you copying? It sounds like you have a split application (a
"frontend" containing forms, reports, code etc. linked to a "backend"
containing tables). Are you copying just the frontend, or both?

You may be able to solve the problem by using Tools... Database Utilities...
Linked Table Manager to link to the (new or previous) location of the backend.

 

[Jerry Whittle]

Open up the database. Go to Tables in the database window (I'm assuming 2003
or earlier). Do you see any arrows pointing at the table icons? If so the
database has links and has probably been split.

If so you need to go up to Tools, Database Utilities, Linked Table Manager
and find the linked tables.