Fresh Copy

[alpapak via AccessMonster.com]

Fresh Copy
------------------------------------------------------------------------------
--

hi
i have a Db and i want to empty all my entries and distrubute it

how can i do it??

I know that i can open the tables and delete everything but it will start
counting not from the begging

thxs

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200603/1

[Wayne Gillespie]

Re: Fresh Copy

On Wed, 15 Mar 2006 07:47:50 GMT, "alpapak via AccessMonster.c om" <u19061@uwe>
wrote:
[color=blue]
> Fresh Copy
>------------------------------------------------------------------------------
>--
>
>hi
>i have a Db and i want to empty all my entries and distrubute it
>
>how can i do it??
>
>I know that i can open the tables and delete everything but it will start
>counting not from the begging
>
>thxs[/color]

Delete all your data and then compact the database. After compacting all
autonumbers will start from 1 again.


Wayne Gillespie
Gosford NSW Australia

[Larry Linson]

Re: Fresh Copy

You can't use this trick now, but you can the next time. Create the tables
in the Front End, and never store data in those. Use them as "templates" via
CopyObject to create a new, empty database from code. It is handy if you
have a "sample" database for users to use for practice, a separate
production database, or want to start your data over as you describe.

Larry Linson
Microsoft Access MVP


"alpapak via AccessMonster.c om" <u19061@uwe> wrote in message
news:5d47ef6954 1b6@uwe...[color=blue]
> Fresh Copy
> ------------------------------------------------------------------------------
> --
>
> hi
> i have a Db and i want to empty all my entries and distrubute it
>
> how can i do it??
>
> I know that i can open the tables and delete everything but it will start
> counting not from the begging
>
> thxs
>
> --
> Message posted via AccessMonster.c om
> http://www.accessmonster.com/Uwe/For...ccess/200603/1[/color]