Access VBA - Attach tables

[LCO]

hi,
I try to change the attach path with VBA in access 97.
But, I don't find the correct way.
Exemple: tables : -> c:\test\customer.dbf
change by
-> c:\test2\customer.dbf

thanks for the solution
LCO

 

[leckie]

I tried this using a combo box where "locat" is the new location of the dabatase

Link (Me![locat])
MsgBox "Done"

this way any tables which are linked to this db are also linked.

hope this helps

regards Leckie