Copy all the tables from MS Access(.mdb) to another MS Access(.mdb) at once (Structure Only)

0
votes

How to copy all the tables(global and local) from one MS Access file(.mdb) to another MS Access file(.mdb) with structure only. The MS Access file is linked with SQL server. If I try export option in MS Access, it creates a link table which I don't want. Is there any code in VBA to copy all the tables at once and paste only the structure of tables to another MS Access file ?

1
sql-serverms-accessvbams-access-2007
Do you want to create (empty) local tables from the linked SQL Server tables? – Andre
Yes, I want to create empty local tables from MS Access linked with MS SQL Server. – Yash R.
Oh. This is completely different from a "copy", it is a full migration. Please edit your question accordingly. But it is probably off-topic - too broad or "find a tool". – Andre

1 Answers

0
votes

Open the target database and go to External Data.

Click Access, select the source file, and mark Import tables etc. and click OK.

Select tab Tables, click Select All, and click Settings >>.

Under Import Tables mark Definition only. Click OK.