Linked Tables

  • Thread starter Thread starter Melissa
  • Start date Start date
M

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
 
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
 
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.
 
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"?
Click to expand...
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 <--
 
Back
Top