Linked Tables

  • Thread starter Thread starter Vel
  • Start date Start date
V

Vel

Hello,

I was just wondering how to update the location of linked
tables. i.e. I move the backend from C:\myFiles\Backends
to C:\myFiles\Database\Backends

This isn't exactly what I'm doing, but you get the
picture.

Vel
 
The easiest way is to used the Linked Table Manager add-in to do this. Where
this add-in is depends on what version of Access you're using, though. In
Access 97, for example, it's under Tools | Add-ins, whereas in Access 2000,
it's under Tools | Database Utilities

It's also possible to change the linkages in VBA code. See
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web" for one
approach.
 
Back
Top