1. Is there a way to have multiple users log into a program driven by access. Bypassing the lockfile and not getting the open table error.

2. What would be the best way to make a number "autonumber" without using the autonumber function in access. I'm making a small purchase order program for a company and they need purchase orders starting at 1467. Right now i'm using an ini file but is there an easier way? and if two users are on simutaineously?