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.
-----Original Message----- From: ellwood [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 15:31 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: resetting autonumber in Access Not sure about Access but if you have cleared out the table, in SQL Server you TRUNCATE like this TRUNCATE table tblSomeTable -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 03 February 2004 15:24 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: resetting autonumber in Access > How do I reset this to start at 1? I have tried turning it into a number > field and back, have also tried deleting the field then putting it back. > Neither of these seemed to work. Do the repair / compact thang. -- Aidan Whitehall <mailto:[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 <http://www.fairbanks.co.uk/go/awards> Fairbanks uses anti-spam filtering. If you sent an e-mail and expected to receive a response but didn't, please call -- it may be that your e-mail didn't make it to the intended mailbox. ________________________________________________________________________ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ -- ** 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] -- ** 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] -- ** 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]
