Number Field Problem in conversion from 2000 to 2007

[MikeD]

Hi, I have just upgraded from Office Professional 2000 to Office Professional 2007, and in the conversion process all the numbers in my number field have changed, this field has the primary key assigned to it as the whole idea is to keep the numbers unique to each record, my problem now is that a search on a number in my database in Access 2000 no longer relates to the number in Access 2007. The Access 2000 database gives numbers beginning with 1 and ending in 13,678, but the Access 2007 database gives numbers beginning with 26,127 and ending in 39,805, so still the same 13,678 records but numbered in a somewhat bizarre fashion. Any suggestions on how I can return the numbers back to 1 to 13,678 in Access 2007 would be gratefully received, regards Mike

 

[llkhoutx]

What's the datatype of the field?

Repair and compact before you convert your database.

Alternatively, if the "number field" is an auto number datatype. Change it to long integer datatype then convert the database. Following the conversion, add an auto number field. and build a query to update the auto number field with the number field value. Finally delete the number field column and name the auto number field appropriately.

 

[MikeD]

Hi, many thanks for your helpful response and after two attempts I can report that my database in Access 2007 now reads 1 to 13678 in the record number field, and is working fine. As I am now fully converted to the 2007 version I have copied the old Access 2000 database to a CD and archived it, just in case. I am hoping that I will become more conversant with the 2007 version with use as I have only been using it for two weeks and am finding the learning curve a little confusing at times, but after eight years of using the 2000 version I suppose I have become set in my ways and the change is quite startling, again many thanks for your prompt advice, regards Mike