How do I copy a database structure?

G

Guest

How can I copy a database without copying the records?

A company is opening another division and wants to start with the same
database structure (but not all the data). We'd like to copy the current
database, but don't want to have to go through all the tables and delete
records.

What is the easiest/quickest way to accomplish this?
Thanks in advance for feedback!
 
G

Guest

Create a new MDB, select import, and select the original mdb you want to
import the tables from.
press the option button, on the buttom of the screen there will be more
option for te import, from there select structure only, without the 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

new database with duplicate structure 2
Saving tbl structure from one database to another 11
Copying Database Structure 2
Delete all records 2
How do I copy an entire MS Access database? 2
ACCESS 2003 SP3: "The database has been placed in a state by user 4
How do I create an empty copy of an Access database? 1
How can I copy an entire MS Access database? 1

Top