VB & Database, Fresh Access 97 database !! help please

Steve Lupto
#1 / 6

Fresh Access 97 database !! help please

Delete the records and then compact the MDB.

Quote:

>Hello everyone,
> I would need to know how to clear up a Access97 database to start every
>record with an autonumber to 1 to ship with my VB5 program. Simply deleting
>records doesn't do the trick.
> Thanx in advance
> Dave

Tue, 15 May 2001 03:00:00 GMT

David Bafr
#2 / 6

Fresh Access 97 database !! help please

Hello everyone,
I would need to know how to clear up a Access97 database to start every
record with an autonumber to 1 to ship with my VB5 program. Simply deleting
records doesn't do the trick.
Thanx in advance
Dave

Thu, 17 May 2001 22:43:00 GMT

Luc Segui
#3 / 6

Fresh Access 97 database !! help please

you just have to delete all record from that table and then go in access
and open your table to modify the structure. You just delete the field that
you auto increment and create it again. This wil have the effect of starting
your number back to ONE.

Luc Seguin

David Bafri a crit dans le message

Quote:

>Hello everyone,
> I would need to know how to clear up a Access97 database to start every
>record with an autonumber to 1 to ship with my VB5 program. Simply deleting
>records doesn't do the trick.
> Thanx in advance
> Dave

Fri, 18 May 2001 03:00:00 GMT

Craig Mello
#4 / 6

Fresh Access 97 database !! help please

There is an easier way of doing it without deleting the field.

After deleting all records simply compact the database and that resets all
your counters

----
Craig

Quote:

> you just have to delete all record from that table and then go in access
>and open your table to modify the structure. You just delete the field
that
>you auto increment and create it again. This wil have the effect of
starting
>your number back to ONE.

>Luc Seguin

>David Bafri a crit dans le message

>>Hello everyone,
>> I would need to know how to clear up a Access97 database to start every
>>record with an autonumber to 1 to ship with my VB5 program. Simply
deleting
>>records doesn't do the trick.
>> Thanx in advance
>> Dave

Mon, 21 May 2001 03:00:00 GMT

Adrian Edward
#5 / 6

Fresh Access 97 database !! help please

1) Delete all the records
2) Compact the database.

Compacting a database resets the AutoNumber field to 1 more than the highest
number in use. If the table holds no records then the first number is
always 1.

Adrian

Quote:

>There is an easier way of doing it without deleting the field.

>After deleting all records simply compact the database and that resets all
>your counters

>----
>Craig

>> you just have to delete all record from that table and then go in access
>>and open your table to modify the structure. You just delete the field
>that
>>you auto increment and create it again. This wil have the effect of
>starting
>>your number back to ONE.

>>Luc Seguin

>>David Bafri a crit dans le message

>>>Hello everyone,
>>> I would need to know how to clear up a Access97 database to start every
>>>record with an autonumber to 1 to ship with my VB5 program. Simply
>deleting
>>>records doesn't do the trick.
>>> Thanx in advance
>>> Dave

Mon, 21 May 2001 03:00:00 GMT

Tim
#6 / 6

Fresh Access 97 database !! help please

With ASP scripts I have always deleted the records, saved the field in
question as a Text field, then changed it back to a autonumber field then
save again, but I see that compacting it works..That's great..
Tim

Quote:

>Delete the records and then compact the MDB.

>>Hello everyone,
>> I would need to know how to clear up a Access97 database to start every
>>record with an autonumber to 1 to ship with my VB5 program. Simply
deleting
>>records doesn't do the trick.
>> Thanx in advance
>> Dave

Tue, 22 May 2001 03:00:00 GMT