How do I create an empty copy of an Access database?

G

Guest

I have an MS Access 2003 database with about 100 tables and 300 queries. How
can I copy only the structure of this database so that I can use it as a
template for other purposes? Or alternatively: how can I delete all data from
a database easily while keeping its structure intact?
 
G

Granny Spitz via AccessMonster.com

J_o_e_r_g said:
So my question is: how can I copy the entire
structure of a database without its data?

Create a new database file and go to File | External Data | Import and browse
to the DB you want to copy. Use Select All on all tabs. Click on Options.
Make sure Relationships, Menus and Toolbars, and Import/Export Specs check
boxes are checked. Click on Definition Only in the Import Tables section.
Click on OK and all objects will be imported 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

Top