Inserting a record in SQL Server and retrieving key ID.
There are many ways to insert records and retrieve that records key value, this approach will probably be among the quickest since all of the processing occurs on the server, not in Access. The techni [...]