deleting records in a access table
-
how to reset the autonumber id when deleting records in a table......meaning how to have the id starting at 1 again
In Access, first delete the rows, then switch to design mode, change the datatype of the autonumber field to whatever, save the table. Change back and save again!. This can only be done on an empty table (I think), and I am not sure you can do it externally. If it is possible you would need to drop and then create the table using SQL syntax. Consultant, system/web developer. IMS Consulting AB, Sweden
-
In Access, first delete the rows, then switch to design mode, change the datatype of the autonumber field to whatever, save the table. Change back and save again!. This can only be done on an empty table (I think), and I am not sure you can do it externally. If it is possible you would need to drop and then create the table using SQL syntax. Consultant, system/web developer. IMS Consulting AB, Sweden
Another way to do it is after deleting the rows compact the database. Best regards, Mark www.mjsoft.co.uk