Linking SQL tables

[chrisdd]

Hi,

I'm using the standard link to tables VBA script found here



All of my tables are stored in a local table - only issue is, is that when I add the names of the new tables into the local table to be linked -they don't appear as linked tables?

All of my existing tables that I've been using for ages work fine - the new tables that I have created and have key fields which have the identity specification switched on.

Any help would be much appreciated.

 

[theDBguy]

Not sure I follow without seeing what you got. Can you post some screenshots? Also, can you post the code in question?

 

[Gasman]

Crossposted? https://www.accessforums.net/showthread.php?t=84772