Retrieve the identity for the inserted record. Set the @displayNumber value now that you have the just-inserted record's identity.

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 ...

SQL Server has come a long way in the past 5 years, though the history seems to linger. Let's look at the recent history and see what the story is with database vulnerabilities.

One Identity announced that its One Identity Safeguard solution now supports Microsoft SQL Server 2017 and SQL Server 2019 database environments. Microsoft was positioned as a Leader in the 2019 ...