mkelly Registered User. Local time Today, 15:19 Joined Apr 10, 2002 Messages 213 Feb 24, 2004 #1 Autonumber?? I have a DB with a records table. Somehow the autonumber field changed to a number field? Any ideas how this could have happend? Is there anyway to turn it back into an autonumber? any help appriciated.
Autonumber?? I have a DB with a records table. Somehow the autonumber field changed to a number field? Any ideas how this could have happend? Is there anyway to turn it back into an autonumber? any help appriciated.
M MadMaxx .NET foo Local time Today, 16:19 Joined Jun 27, 2003 Messages 138 Feb 24, 2004 #2 Don't know how that could have happend but just change it back in the Design View for the table
mkelly Registered User. Local time Today, 15:19 Joined Apr 10, 2002 Messages 213 Feb 24, 2004 #3 MadMaxx said: Don't know how that could have happend but just change it back in the Design View for the table Click to expand... Tried that can't change a primary key once data is entered and I have 74000 recoerds in there
MadMaxx said: Don't know how that could have happend but just change it back in the Design View for the table Click to expand... Tried that can't change a primary key once data is entered and I have 74000 recoerds in there
M MadMaxx .NET foo Local time Today, 16:19 Joined Jun 27, 2003 Messages 138 Feb 24, 2004 #4 Strange. I can change a key in one of my tables.
M MadMaxx .NET foo Local time Today, 16:19 Joined Jun 27, 2003 Messages 138 Feb 24, 2004 #5 This might help you out Convert Number To AutoNumber
