copying a database

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

Guest

I've created an access database that I want to use as a template. How do I
copy the structure of the database, but not the test records I enterred?
 
Create a new database. Go to File | Get External Data | Import.

You'll be able to select the original database from the Browse window. When
the wizard window shows up, click Select All button for each of the tabs so
that you'll get all objects. Then click Options button and select the option
button for "Definition only" under the "Import Tables" heading.
 
You must log in or register to reply here.

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

Record-Locking remains open after closing 0
Copy and move Access 13 database on laptop to pc with Access 13 0
Clean all "data" from a database 3
How can I copy an entire MS Access database? 1
How do I create an empty copy of an Access database? 1
Delete all records 2
How can I save a blank version of an existing Access database? 6
Saving tbl structure from one database to another 11

Back
Top