J
jo
Hi guys how can I create a fresh empty database from a original database
currently in use?
Thanks jo
currently in use?
Thanks jo
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
jo said:Hi guys how can I create a fresh empty database from a original database
currently in use?
Thanks jo
D
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)
data in them, or everything else? And why do you need to do this? (there may
be better ways of achieving your goal)
J
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.
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.
J
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
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
L
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
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
J
jo
Hi John brilliant that worked a treat thanks!!
John Spencer said: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
.
J
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
info that would take me ages to enter again. Thanks
Jo