I suspect that a Jet call to modify a field to identity might exist, but I have no idea what it is if it does.<BR><BR>If you're going to eventually be using SQL server, I highly suggest downloading an ...

Arithmetic overflow error converting IDENTITY to data type int. This error occurs when attempting to insert a value that exceeds the data type limit of an IDENTITY ...

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...