Prev: Why can't a primary key be duplicated?
Next: change the default opening of a form to enter a new record
From: jo on 26 Mar 2010 05:40
Hi guys how can I create a fresh empty database from a original database
currently in use?
Thanks jo
From: 136899587 on 26 Mar 2010 06:46


"jo" <jo(a)discussions.microsoft.com> 写入消息
news:ABE2D033-E7AF-41C6-9331-4D6F39C69A47(a)microsoft.com...
> Hi guys how can I create a fresh empty database from a original database
> currently in use?
> Thanks jo

From: Douglas J. Steele on 26 Mar 2010 07:39
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)

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"jo" <jo(a)discussions.microsoft.com> wrote in message
news:ABE2D033-E7AF-41C6-9331-4D6F39C69A47(a)microsoft.com...
> Hi guys how can I create a fresh empty database from a original database
> currently in use?
> Thanks jo


From: jo on 26 Mar 2010 09:35
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.

"Douglas J. Steele" wrote:

> 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)
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/DJSteele
> (no e-mails, please!)
>
> "jo" <jo(a)discussions.microsoft.com> wrote in message
> news:ABE2D033-E7AF-41C6-9331-4D6F39C69A47(a)microsoft.com...
> > Hi guys how can I create a fresh empty database from a original database
> > currently in use?
> > Thanks jo
>
>
> .
>
From: John Spencer on 26 Mar 2010 10:22
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 wrote:
> 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.
>
> "Douglas J. Steele" wrote:
>
>> 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)
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://www.AccessMVP.com/DJSteele
>> (no e-mails, please!)
>>
>> "jo" <jo(a)discussions.microsoft.com> wrote in message
>> news:ABE2D033-E7AF-41C6-9331-4D6F39C69A47(a)microsoft.com...
>>> Hi guys how can I create a fresh empty database from a original database
>>> currently in use?
>>> Thanks jo
>>
>> .
>>
 |  Next  |  Last
Pages: 1 2
Prev: Why can't a primary key be duplicated?
Next: change the default opening of a form to enter a new record