Easiest way to do this is to create a temp table to hold data. Delete all rows from real table then append the data back into it from the temp table. Not much of any other way I know of to do this.
At 01:30 PM 11/19/2002 -0600, you wrote: >While working an access db, the autonumber on the primary key filed was lost >somewhere along the way. I've already got quite a few records populated in >this and a few other tables dependent on those keys, so I can't >drop/recreate the column. However, access won't allow me to turn the >autonumber back on. Is there any way around this? > >Matthew P. Smith >Web Developer, Object Oriented >Naval Education & Training Professional >Development & Technology Center >(NETPDTC) >(850)452-1001 ext. 1245 >[EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
