When you use the upsizing wizard you can define each field. So make sure that you are telling the SQL that you want the Access PK to be PK.
matt -----Original Message----- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 4:48 PM To: CF-Talk Subject: Convertnig MS Access database to SQL server Hi me again :) I just converted an access database to SQL server for the first time. I had all the primary keys set to autonumber's (no duplicates) in access but when I converted to SQL server it simply made them Int's. I had to go through and set each table's primary key to identity. Is there something I'm missing that will do this for me when I convert so I don't have to manually set them every time or should I write some code to get the max id of the primary key and increment it before I insert the new row? ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
