Identity ID - Incrementing by 2 not 1

[sipps]

Hi all,

I have a strange issue. When entering new records into my table, the auto-id number does not show. When I close the window down and open it again using return all rows, it shows the records and their id numbers.

The problem is the ID numbers are incrementing by 2 not 1.
I have double checked the table design and yes, it's definitely set to increment by 1 each time.

My other tables are fine, it's just this one. I'm not using any SQL keywords or anything, I just thought that it might be a bug?

Cheers

 

[hneal98]

Could be a bug, I would just create another table similar to that one and copy the data to it and delete this one.