MS Access data conversion - Copy a Database

Author

Copy a Database

Chuck Moore

2005-11-28, 8:28 pm

I have created several databases for use at the local hospital's ER and they
are very pleased with the results. They now wish to distribute them to other
hospitals in the province. Is there a convenient way to copy the database
without all of the accumulated data so that we can forward an "empty"
database?

Stu Smith

2005-11-29, 1:24 pm

The easiest way to do this would be to create a new .mdb and import all the
objects. When you import tables, select "Definition Only". Save the new
database and make as many copies of that as you want in Explorer.

"Chuck Moore" < ChuckMoore@discussio
ns.microsoft.com> wrote in message
news:CCAA3936-9E36-492E-A1B6- 3A2D5845070F@microso
ft.com...
> I have created several databases for use at the local hospital's ER and
they
> are very pleased with the results. They now wish to distribute them to
other

> hospitals in the province. Is there a convenient way to copy the database
> without all of the accumulated data so that we can forward an "empty"
> database?

Sponsored Links