Duplicate Autonumber Field

[MsJami]

I have an autonumber field that is my pk and it is now creating duplicate numbers.
I can't seem to get it to stop,
any suggestions would be greatly appreciated
Thank You
Jami

 

[r937]

compact/repair the database

if that doesn't solve it, drop the table, delete the database, format your hard drive, reinstall your operating system, reinstall your database, redefine the tables, and reload them with data

that oughta do it

just kidding

how do you know there are duplicates?

have you done this:

select pk from mytable group by pk having count(*)>1

what other columns are in the table?

rudy

http://r937.com/

SQL Consulting

 

[MsJami]

Yes I ran a find duplicates query then, I went in and deleted the duplicates, compact and repair and try to ad those items again. No luck.
My columns are:
Timebilledid,projectid,job#,empid,billingdate,hourlyrate,
billablehours,subsistence.

This is a table to track time spent on each project and to calculate hours.

My highest number 645 and it keeps jumping to the 200's.
I am at my wits end with this
Jami

 

[MsJami]

Also I should mention that I had appended and deleted projectid's that we are no longer working on. I don't know if that has anything to do with it, so my number are out of order now anyway.
Jami

 

[r937]

sorry, none of that info brings me any closer to understanding what's wrong



rudy

http://r937.com/

SQL Consulting