reset the sequence to whatever you want...there's bound to be a way in
Access.
---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts
Nick Baker wrote:
> MS Access
> CF 5
>
> Can you reset rows numbers back to starting at row number 1 in a DB,
> after
> deleting all rows?
>
> The goal is to totally erase and restore DB, on the fly, from time to
> time.
> New info will have the same columns, but a different number of rows each
> time. The Delete Row function of a CFQUERY will do this, but the new row
> number starts where the delete row numbers left off. We will
> eventually run
> out of row numbers.
>
> Or is there another way to do this, e.g., delete and regenerate the table
> anew on the fly?
>
> Thanks,
>
> Nick
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
