Just create another column with the same name, make it autonumber and primary key...THEN delete the original column.... has worked for me.
-----Original Message----- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 20 November 2002 8:31 a.m. To: SQL Subject: re-autonumber access column 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
