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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply