Linked table manager to be changed from (X:\) a server drive to (C:\) a local machine
Open items in your TableDefs collection and change the Connect property of
each TableDef:
dim dtef as tabledef
for each tdef in currentdb.tabledefs
if left(tdef.connect,1)="X" then
tdef.connect="C" & mid(tdef.connect,2)
end if
next
HTH
- Turtle
Quote:
> Could you help me automate the linked table manager from
> X:\95Access\Data\City.Mdb (the server)
> To C:\95Access\Data\City.Mdb (the work station)
> Your help is appreciated
> --
