----- Original Message ----- 
From: "ellwood" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 03, 2004 3:32 PM
Subject: RE: [ cf-dev ] OT: resetting autonumber in Access


> Of course the other way is to convert it to number, rename it, create a
new
> column with autonumber with the original name, then delete the renamed
one.
>


 or copy the table structure to a new table, then rename it back to the
original name. Assuming you want to start with an empty table of course.

paddy


-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to