create an empty program?

[jo]

Hi guys how can I create a fresh empty database from a original database
currently in use?
Thanks jo

 

[Guest]

Hi guys how can I create a fresh empty database from a original database
currently in use?
Thanks jo

 

[Douglas J. Steele]

What's your definition of "a fresh empty database"? Just the tables with no
data in them, or everything else? And why do you need to do this? (there may
be better ways of achieving your goal)

 

[jo]

Hi thanks for yr reply, a sister company of my work place would like me use
their Access database for simular type of work here, but they wanted to know
how I could copy or achieve this? It would be the whole thing and also all
free from past data so its like a brand new database that has not yet been
used. I think they will either zip the file or put it on cd? It also needs to
be translated from swedish to english but they are going to do that.

 

[John Spencer]

Open a new database
Import everything from the existing database using the menu item -
Get External Date, Import
Click on the options button and under Import tables select Definition Only

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Larry Linson]

Actually, before following John's advice, you should analyze what you
have... there may very well be "lookup tables" which contain reference data
that will be identical, no matter which company, or in which location, the
application is used. You don't want to have to re-enter that kind of data.
An example might be corporate information for your parent company, a table
used to determine when quarters are deemed to start/finish, or a table
defining fiscal years, etc..

Larry Linson
Microsoft Office Access MVP

 

[jo]

Hi John brilliant that worked a treat thanks!!

Open a new database
Import everything from the existing database using the menu item -
Get External Date, Import
Click on the options button and under Import tables select Definition Only

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

.

 

[jo]

Hi Larry good advice and well needed I as I nearly did not bring over some
info that would take me ages to enter again. Thanks
Jo