Replace 4 local tables with linked tables and make them local tables using VBA code

Is there a way to delete 4 local tables with linked tables and then make the linked tables local tables using VBA code?
SteveL13Asked:
Who is Participating?
 
Gustav BrockCIOCommented:
Yes:

Create a new database.
Export the tables to the new database.
Delete the tables from current database.
Link the tables from the new database, The table names will not have changed.
0
 
aikimarkCommented:
This question doesn't make any sense.  Please clarify.
0
 
SteveL13Author Commented:
Here is my situation. I have 4 linked tables in my database. But because of network speed issues I need to delete those linked tables and re-link to them BUT then convert them to local tables.

I hope this makes sense now.
0
 
Gustav BrockCIOCommented:
It did and still does.
0
 
aikimarkCommented:
re-link to them
No.  You wouldn't relink to them if you were going to import their data into local tables.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.