Ok the way Im doing it now is to create an ID count table. So when I add a new record I set it's ID to the count table. I add one number to the count table once the record was created for the next record's ID.

Let's use the following example:

Table = Users
Fiield1 = ID
Field2 = Name

Table = IDCount
Field = ID

So when I add a new User, I first reference the IDCounttable