Linked Table Manager in Access 2003

H

Hank

In using the Linked Table Manager in Access 2003 I am prompted to link each
of my tables even though I checked all of them. I also checked "Always
prompt for new location". In Access 2000 I was able to do them all at once.
Is there some setting I am unaware of? Thank you for any help.
 
A

Albert D. Kallal

In using the Linked Table Manager in Access 2003 I am prompted to link
each
of my tables even though I checked all of them. I also checked "Always
prompt for new location". In Access 2000 I was able to do them all at
once.
Is there some setting I am unaware of? Thank you for any help.
Click to expand...

As far as I can remember, a2000, and a2003 work the same.

however her is a little trick that might help:

If your back end has MORE then one mdb file, then if you try and link to
multiple files, then you get a prompt each time to browse to the file.So,
just select (check) all the tables from the SAME back end file..and you
don't get prompted each time.
 
H

Hank

Thank you Albert. I did verify that all the tables do point to the same mdb
and I still get prompted for each one. Any other suggestions would really be
appreciated.
 
A

Albert D. Kallal

Gee, like I said, when more then one back end is involved..it prompts each
time. However, in your case, I don't know why you get a prompt for each
file....somthing is a miss here...

I guess you could just throw together you own little re-link system, and
then type in the back end name.

You can find the code here:

http://www.mvps.org/access/tables/tbl0009.htm
 
H

Hank

Thank you Albert. You encouraged me to look at my list of tables more closely
and found that there was a linked table that was deleted from the backend
database thereby causing a reason to link each and every table. I also
appreciate your responsiveness.
 
A

Albert D. Kallal

Thank you Albert. You encouraged me to look at my list of tables more
closely
and found that there was a linked table that was deleted from the backend
database thereby causing a reason to link each and every table. I also
appreciate your responsiveness.
Click to expand...

You are most welcome, and thanks for coming back and explain your solution.
Now,I also know that both "different" tables, and *ALSO* if a table is
missing can cause this problem!

So, you see...we both just learned somthing here!!
 
Top