Copy Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Chuck Moore said:
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?
Click to expand...

Copy the database file and empty the tables. Keep the result as a template
and distribute on the media of your choice. Or am I missing something from
the question?

Keith.
www.keithwilby.com
 
Hi, Chuck.
Is there a convenient way to copy the database
without all of the accumulated data so that we can forward an "empty"
database?
Click to expand...

Yes. Create a new database file. Select the File -> Get External Data ->
Import... menu to open the Import dialog window. Navigate to the database
file that you want an empty copy of and select the name to open the Import
Objects dialog window.

Select every tab in the Import Objecs dialog window, and select the "Select
All" button to highlight every item on each tab. When finished, select the
"Options >>" button and ensure that the "Relationships," "Menus and
toolbars," "Import/Export Specs" check boxes in the "Import" section are
checked and the "Definitions only" item in the "Import Tables" section is
selected. Select the "OK" button to import all objects. Open any module in
the VB Editor in the new database and compile the code, then compact the
database.

The new database is a copy of the old database, sans the data. Use this
empty database as a template and send copies of this one to all other
hospitals.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Back
Top