Duplicate Problems

[RabSwinney]

Hi,
I designed a database at work and they want to go group wide with it, the IT department put the tables onto sql and the database slowed down, then they used a citrix server now the speed is ok but I am getting a lot of duplicate autonumbers? HELP!!!!!

 

[BBaggins]

How did you implement your autonumbers?

I presume it is no longer an Access database, and they created a SQL Server database with the same design. That would have involved changing Access Counter fields to SQL Server Identity columns. That should have worked OK.

However, if you are using counter fields in an autonumber table, and the counters are incremented by your application, then you need to implement a stored procedure that locks the table while retrieving/incrementing the autonumber counter. Otherwise, two users might get the same autonumber value.