I'm using an Access database in my application, for adding new records i want to automatically create the number used in my primary key(ie:ProductID) but i don't want to use the Auto Number feature in Access how could i simply add 1 to the last record in the database and have it displayed as the new ProductID and let the user input the rest of the information?

I'm using a DataGrid with it's Datasource = DataEnvironment1