Help with Linked tables

[JimUK]

I have an existing Access 2000 database (.mdb). It has many linke dtables in it. I am trying to change a table's specs. but can't get to it since it's linked. If I take the link away the table disappears. Is it still in the .mdb? Microsoft says that you can re-l;ink to it again....but not if it's not there?? All I need to do is edit some of the field sizes within that table. Can anyone help me on this one please!

Jim

 

[RickSpr]

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

 

[JimUK]

Hey Thanks, that did the trick!

Jim

 

[twilleez]

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

 

[DoorV]

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?