Create copy of database without data

  • Thread starter Thread starter Frank
  • Start date Start date
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
 
just create a new blank database and import everything you need from the
original with the option structure only

bon chance
 
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



.
Click to expand...
 
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.
 
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.
Click to expand...

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
 
chriske911 said:
just create a new blank database and import everything you need from the
original with the option structure only
Click to expand...

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
 
Back
Top