Linked Tables

[Melissa]

Hi there

I have copied the "front end" of our database onto my pc off of the
reception pc. Now i am getting an error message saying that the "back end"
is not being located, and the path is incorrect. How do I change "where
access is looking for the back end"?

Thank you

Melissa

 

[Maurice]

You should look for the option "Linked Table manager". Depending on the
version you are using you can find it here:

2003: Tools - database utilities
2007: Tab database tools

 

[Melissa]

Hi Maurice

Thank you

But the "Linked Table Manager" is "greyed out" ?

 

[golfinray]

Try right clicking on your table name then down at the bottom it should say
link table manager for re-linking that table. It is possible that your pc
doesn't "see" the BE at all, in which case you may have to import a couple of
those tables and then see if the greyed out command is gone.

 

[Stefan Hoffmann]

hi Melissa,

I have copied the "front end" of our database onto my pc off of the
reception pc. Now i am getting an error message saying that the "back end"
is not being located, and the path is incorrect. How do I change "where
access is looking for the back end"?

Does the back-end is stored on a server? Then link your tables against
the UNC path (\\server\share\yourBackEnd.mdb). Don't use a mapped drive.


mfG
--> stefan <--