I want to reset the autonumber function in an existing Access database, preferably in a procedure that does not require any sort of programming (I am not a programmer). If the procedure does require some programming, please provide some helpful insight.
As of right now, the steps that I have been give by another person from my dept is not working. The instructions are listed below:
-select tools (menu) and check display database window, close and reopen program.
-select targeted table and open it in design view
-select autonumber cell and change it to text, save program
-Then select same cell and change it back to autonumber to save program
After following these directions, I received a pop-up window with the following message:
"Once you enter data in a table, you cannot change the data type of any field in the autonumber, even if you have not added data to that field. Add a new field to the table and define it as autonumber."
THX
As of right now, the steps that I have been give by another person from my dept is not working. The instructions are listed below:
-select tools (menu) and check display database window, close and reopen program.
-select targeted table and open it in design view
-select autonumber cell and change it to text, save program
-Then select same cell and change it back to autonumber to save program
After following these directions, I received a pop-up window with the following message:
"Once you enter data in a table, you cannot change the data type of any field in the autonumber, even if you have not added data to that field. Add a new field to the table and define it as autonumber."
THX