Access Table HELP!!!!

[kovas]

A few questions here...

I have a customer info table. When I view it in Ascending sort it shows 7824 records, When I view it in Descending it shows 8764. Why is that?

I use CustomerID as an autonumber which should be unique?

But for some reason I have a few customers with a duplicate ID. I tried to delete the duplicates but it wouldnt met saying that "The search key was not found in any record"

I tried changing CustomerID for the duplicates and it wouldnt let me.

After all this I decided to Repair the database. When I go to Compact and Repair the Database in tools, it deletes all the records with an ID higher than 7849. Basicly it only keeps the records that I can see in Ascending Sort. But like I said when I sort Descending there are 1000 extra records that I can see, which get deleted when I use the repair feature.

Any help/suggestions greatly appreciated, thank you

 

[JeremyNYC]

Kovas,

Please don't waste our time by posting the same thing in more than one forum. You're asking a ton of people to help you out with something as it is, by posting in one place. That's cool--that's the model we're expecting. But if you post it in more than one place, it's quite likely that you'll get an answer in one spot and then some poor sot like me will try to help you out in the other forum, after you've already got the answer.

I assume you didn't do this intentionally, and that you wouldn't have done this if it had occurred to you that several people might spend their time answering the same question, so I don't mean to attack you.

Jeremy

PS: If you're going to help answer this question, please do so in the other thread, which is in the other topics forum (thread181-405936) =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.