How can I copy an entire MS 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?
 
V

Vinayak N

Hi,

- Create a new blank database.
- Import from your original database
- On th import wizard select all the objects from all the tabs.
- Click on options and click on 'definition only'

And then click on import.

Regards,
Vinayak.
 

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