I set up users in a database on a daily basis. There has been a recent change where I need to assign each of them to a number between 800 and 899, in sequential order. How can I do this, using VB or ACCESS, so that the variable isn't lost when the application is closed? In other words, if I add a user today and it's assigned 820, when I close the program, and reopen it tomorrow, I need it to pick up where it left off with 821 as the next assigned number.