relinking tables

  • Thread starter Thread starter courtney
  • Start date Start date
C

courtney

When I attempt to relink a front-end tables to back-end
tables, Access is requiring that I relink one at a time
whereas before I could do the select-all and it would
relink in one swoop. I am still doing the "select all"
but it is taking me through each individual table?

Any suggestions?
 
Tools/Database Utilities/Database manager
This will work for changing your test links to you
production links
I do not know why select all does not work

Jim
 
courtney said:
When I attempt to relink a front-end tables to back-end
tables, Access is requiring that I relink one at a time
whereas before I could do the select-all and it would
relink in one swoop. I am still doing the "select all"
but it is taking me through each individual table?

Any suggestions?
Click to expand...
 
Normally, you can re-link all of the files at once.

However, if you have MULTIPLE back ends, then you have to do it one by one.
In fact, what you can do is highlight all of the "SAME" tables from the same
back end, and then it will re-link all to the same back end. You can then
select all of the files from another back end, and again re-link.

However, if all tables are linked to ONE back end, then you should not be
prompted for each table. So, yes..if multiple back ends are linked to that
one front end...it does prompt you for the location of each table...but as
mentioned, try selecting all tables from ONE back end...and re-link. This
should work for you...
 
When I attempt to relink a front-end tables to back-end
tables, Access is requiring that I relink one at a time
whereas before I could do the select-all and it would
relink in one swoop. I am still doing the "select all"
but it is taking me through each individual table?

Any suggestions?
Click to expand...

There's a checkbox at the bottom of the relinker window "Always
prompt..." - make sure it's not checked.
 
This happens when one of the tables you are requesting to link does not
exist anymore. Determine which table no longer exist in your back-end
database and uncheck that link in your front-end.
 
Back
Top