copying a database

O

oldraven

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?
 
K

Ken Snell [MVP]

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