System tables

[al]

Hi,

I'm trying to move a DB from one network drive to
another. When I do, the table becomes inaccessible
because for some reason, it's still trying to access the
table on the original network drive.

I'm hoping to be able to correct this problem by editing
the system tables in the DB. Therein lies the rub. I
don't know how to access these system tables.

Any help would be appreciated.

Al

 

[Guest]

Yes I actually have 2 Dbs linked together. My data is on
one and the linked tables on the other. I figured out how
to display the system object tables, but no help. I still
can't see where the network link is being set.

-----Original Message-----
Al,
Sounds like you have linked tables (your data and program

reside in separate files). Depending on your version of
Access, the Linked Table Manager will be in different
locations. Look in either Tools - Database Utilities -
Linked Table Manager or Tools - Add Ins - Linked Table
Manager. You can then point to the new location of the
data.

 

[John Vinson]

Hi,

I'm trying to move a DB from one network drive to
another. When I do, the table becomes inaccessible
because for some reason, it's still trying to access the
table on the original network drive.

I'm hoping to be able to correct this problem by editing
the system tables in the DB. Therein lies the rub. I
don't know how to access these system tables.

The Systems tables are locked from editing, and their structure is not
documented. That's NOT the right way to fix this problem!

As suggested elsethread - you can use Tools... Database Utilities...
Linked Table Manager; or you can use VBA code to loop through the
Tabledefs collection and reset each table's Connect string. This
requires some expertise in VBA and a clear understanding of the syntax
of Connect (I still get out my copy of the Access Developers' Handbook
when I need to do so).