Autonumber too large?

[splats]

Hello

I have a question regarding autonumbers. I am using them as primary keys between tables. They work fine. I have noticed however, that the autonumber for one table is huge!(presently has only 70 records in it). If i add a new record, the autonumber is at the 400 000+ level. Should I be concerned? How did the autonumber get so large as I have only been developing this database for the past six months and haven't added in and deleted that many records. Should I change the auto number data type to integer + 1 for each new record?

Any suggestions would be appreciated.

Thanks

 

[jfgambit]

At some point, did you "accidently" enter a number in this field?. If this databae is still being developed and does not have "real" data in it, you can delete all the infomration from the table and Comapct and repair the dataabse, this will start the Autonumber back at the lowest nember in the table. If there are no records it will start back at 1

HTH
"I know what you're t'inkin', ma petite. Dat Gambit... still de suave one, no?"

 

[KenReay]

Hi

Or maybe you have it set to use random number instead of next number? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[splats]

Thanks for your input!

I think that i found a solution that works for me. I made a copy of the table design (no data) and added an autonumber field to it. Then I copied over the data from the original table without the original auto number. The new table filled in the new autonumber field again.
I then renamed the original table and deleted its relationships. I renamed the new table and then hooked up the relationships with it. I had to check my linked tables and overall, it went smoothly. Although the process sounds a bit confusing. It worked for me. Luckily, I do not have alot of data to move around so it didn't take too much time!

If you are going to try this folks, Back up! Back Up! Back Up!

thanks again!