Link Table Manager fails

T

Tomer

My Acc97 Linked table manager got following error:
"Invalid Procedure Call or argument".

Microsoft KB article 172347 said it is because the mdb has
some linked tables using file DSN.

Is there any other possible reasons?

Any body knows any code that can loop through my linked
tables to find out if they are of type of file DSN and/or
if they need to relink.

Thanks!
 
G

George Nicholson

I have had failures trying to refresh links to tables that either had a name
change or no longer exist in the source db.
I don't remember if it generated that particular error message, but you
might want to keep it in mind.

The following has several code examples related to linked tables. Enjoy!
http://www.mvps.org/access/tables/index.html

HTH,
George Nicholson

Remove 'Junk' from return address.
 

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

Similar Threads

relinking tables in Access 2000 2
Linked Table Manager - Invalid procedure call 1
Access 97: invalid procedure call or argument using linked table manager 1
Linked Table Manager - No access to folder 1
Link tables disappear 1
ACCESS DSNless connection to SQL 7
Linked table manager interface 1
Link a new table by VBA 3

Top