link table

E

el

Hi all,
Is there any issue on link table with Access XP? We couldn't open any link
table in a database and always ended with an unrecovable error and Access
had to close itself.
 
J

John Vinson

Hi all,
Is there any issue on link table with Access XP? We couldn't open any link
table in a database and always ended with an unrecovable error and Access
had to close itself.

By "link table" you mean a link to a table in a separate .mdb file? or
an external table of some other type?

I'm not aware of any newly introduced limitation on linked tables, and
all my applications use them without incident. I suspect that either
your current database may be corrupt, or the links need to be
refreshed. Try Tools... Database Utilities... Linked Table Manager to
relink the tables, or if need be delete all the links and use File...
Get External Data... Link to create fresh new links.
 
E

el

It's a mdb file with link to tables in a separate mdb file.
I'd tried the relink method but still have the unrecoverable error.

Hi all,
Is there any issue on link table with Access XP? We couldn't open any link
table in a database and always ended with an unrecovable error and Access
had to close itself.

By "link table" you mean a link to a table in a separate .mdb file? or
an external table of some other type?

I'm not aware of any newly introduced limitation on linked tables, and
all my applications use them without incident. I suspect that either
your current database may be corrupt, or the links need to be
refreshed. Try Tools... Database Utilities... Linked Table Manager to
relink the tables, or if need be delete all the links and use File...
Get External Data... Link to create fresh new links.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top