Create copy of database without data

F

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
 
C

chriske911

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

bon chance
 
F

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



.
 
G

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.
 
T

Tony Toews

glenda said:
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
 
T

Tony Toews

chriske911 said:
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
 

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