copy structure of some of the database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to copy some of the forms and tables to a new database, but not any of
the data or queries. Is this possible?
 
goplayoutside said:
I want to copy some of the forms and tables to a new database, but not any of
the data or queries. Is this possible?
Click to expand...

Yes you can do this. From the new database, go to File Get External Data
Import...

Select the database which has the information you want to copy. Then for
each tab (Tables, Forms, etc.) select the objects you want to copy. Then
click the Options >> button. On here you will be given the option to import
the table definitions (without data).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Copy a database 5
TransferDatabase help...totally lost 5
Access Need help in making asset history in my current database. 1
Copy and move Access 13 database on laptop to pc with Access 13 0
Exportt/Copy Structure Only 2
Copying Database Structure 2
Record-Locking remains open after closing 0

Back
Top