Linked Table Manager not working

  • 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??

  • 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

  • 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

  • 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