Create copy of database without data

[Frank]

Is there any way to create a copy of a database,
retaining all tables, queries, reports, VB-modules, etc.,
but without any data.

Of course you can just design a database, and keep that
as the original, copying when needed. But say the damage
has already been done and one has a database with 500 Mb
of data in different tables. Is there a fast way of
getting an empty base with same structure and modules?


Regards,

Frank

 

[chriske911]

just create a new blank database and import everything you need from the
original with the option structure only

bon chance

 

[Frank]

Thanks, just what I needed.

Regards,

Frank

-----Original Message-----
just create a new blank database and import everything you need from the
original with the option structure only

bon chance



.

 

[glenda]

This is faster that redesigning the database from scratch.
Copy the tables (one by one) to a new database but when
you paste the tables, select only the structure without
the data.

If you start with a complete copy, delete the tables and
then copy the tables in the fashion above, it shouldn't
take too long.

 

[Tony Toews]

This is faster that redesigning the database from scratch.
Copy the tables (one by one) to a new database but when
you paste the tables, select only the structure without
the data.

If you start with a complete copy, delete the tables and
then copy the tables in the fashion above, it shouldn't
take too long.

However you then don't have the relationships.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

just create a new blank database and import everything you need from the
original with the option structure only

Use the sysrels utility at the following location to copy the table
relationships layout window
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=12#12

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm