Help with Linked tables
Help with Linked tables
(OP)
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
Jim
RE: Help with Linked tables
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
RE: Help with Linked tables
Jim
RE: Help with Linked tables
RE: Help with Linked tables