Ah, ok.
If you can implement an identity column in the SQL database, it will help in many ways.
I don't believe RecNo() isn't 100% reliable, since it's possible someone could delete a row and then pack, in between the time of data retrieval and then a save. Not a likely scenario, but an identity column is going to be better.