1) Access won't re-use an ID. If someone used ID 19, then deleted it, then made a new one, it would be 20. You have to compact the DB to get #19 back, and that's only if you haven't already used #20, etc.

2) multiuser issues?

3) as you say, double-clicking ;)