The "table" you see in the database window for a linked table is like a desktop shortcut. It's only a reference to a table that exists elsewhere, namely, in another database, or in an Excel spreadsheet or a text file.

To relink it, you need to know where the database is that contains the real table. (That's also where you'll need to edit your field sizes.)

Chances are, it's in the same database as another of your linked tables. If you run the Linked Table Manager (Tools>Add-Ins menu in Access 97; Tools>Database Utilities menu in Access 2000), it will show you the path names to external files that contain each of the linked tables.

Rick Sprague

Hey Thanks, that did the trick!  

Jim

I just made a combo box to a form how do i get the information in the combo to add a table (the table is a linked table won't let me edit) You can email me at Twilleez@home.com Thank you

I am trying to export a access table to a dbase format table for use with other applications, I can do it manually with the export function in access (transferdatabase doesnt seem to work in access basic).. I would like to automate it in VB but cannot find a way to do it.. any help available?