How can I copy an entire MS Access database?

's Computer Specifications

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?

's Computer Specifications

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.

On Oct 13, 7:31 pm, J_o_e_r_g <J...@discussions.microsoft.com> wrote:
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy entire database without data	Sandy	Microsoft Access	12	8th Jul 2008 03:12 PM
Copy an entire database and paste to new database in Access 2003	Chrystela	Microsoft Access External Data	5	4th Jan 2008 07:12 PM
How do I copy an entire MS Access database?	=?Utf-8?B?Sl9vX2Vfcl9n?=	Microsoft Access	2	13th Oct 2006 11:54 AM
How do I copy an entire MS Access database?	=?Utf-8?B?Sl9vX2Vfcl9n?=	Microsoft Access	0	12th Oct 2006 05:12 PM
Is there a way to copy the entire structure of a database without.	=?Utf-8?B?RWR1bWFu?=	Microsoft Access Database Table Design	3	2nd Apr 2005 01:03 AM