Access 2000 - make an ODBC linked db to a local copy

[aprilargyros]

Hi there, I'm trying to make an ODBC linked DB into a local copy, so that I can manipulate data without effecting others that use it.
In Access 2000, how do I remove this link and make it local, yet still keep the data?
Thank you, April

 

[PHV]

Import instead of link.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JerryKlmns]

Or use a make table query based on your linked table, delete the linked and rename the new one accordingly.