Saving Linked SQL Tables

[Please Help]

Hello all,

I have an Access databases that contains linked SQL tables. There are 140
linked tables.

Is there a way to have a macro to turn all the linked tables to the local
tables (both structure and data)?

Thanks.

 

[RickySJr]

The only way you can make those tables local to your Access database is to
import them. If the tables are small then you should not have a problem.
One thing you could do is create another access application and import the
SQL tables into that application. Then create a links to your current access
application. This way you will have a working TEST system that is similar to
your current environment. Any changes you make will not take occur in
production tables.

 

[Please Help]

RickySJr,

Thanks for the solutions. Yes, you are right that I can import them
supposed to linking them. Why didn't I think of that?

Thanks again.