Prev: Why can't a primary key be duplicated?
Next: change the default opening of a form to enter a new record
From: Larry Linson on 26 Mar 2010 18:32
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

"John Spencer" <spencer(a)chpdm.edu> wrote in message
news:%23zbTM$OzKHA.928(a)TK2MSFTNGP05.phx.gbl...
> 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
>>>
>>> .
>>>



From: jo on 28 Mar 2010 14:39
Hi John brilliant that worked a treat thanks!!

"John Spencer" wrote:

> 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
> >>
> >> .
> >>
> .
>
From: jo on 28 Mar 2010 14:41
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

"Larry Linson" wrote:

> 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
>
> "John Spencer" <spencer(a)chpdm.edu> wrote in message
> news:%23zbTM$OzKHA.928(a)TK2MSFTNGP05.phx.gbl...
> > 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
> >>>
> >>> .
> >>>
>
>
>
> .
>
First  |  Prev  | 
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