Saving Linked SQL Tables

  • Thread starter Thread starter Please Help
  • Start date Start date
P

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.
 
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.
 
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.
 
Back
Top