August 1, 2005 at 12:03 pm
I have an Access 2003 front end with multiple tables in SQL2000. All the SQL tables have key identifiers included.
For some reason, when I open the linked table manager it fails to list the tables. If i select all, it works to refresh the tables, but that is not too handy when i want to select only one to refresh or change the location.
Any ideas??
August 2, 2005 at 1:08 am
Eric,
Do you have more than one version of Access on your computer? On my computer with Access 2003 and 2002, I cannot see any tables in the Linked Table Manager when I run Access 2003 (haven't checked it in 2002). This goes for both SQL Server tables and native Access tables. On my other PC, which has just Access 2002, I can see both.
Alan Cossey
August 2, 2005 at 6:09 am
Have a look at MS Knowledge base article 835519, BUG: 'List of currently linked tables may not appear in Linked Table Manager in a database in Access 2003.'
Phillip L. Hagan
August 2, 2005 at 9:35 am
Fixed! Thanks Phillip!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy