How to restart counting from 1 after erasing table in MS Access?

by

In Access 2010 or newer, go to Database Tools and click Compact and Repair Database, and it will automatically reset the ID.

More Related Contents:

  1. Combine values from related rows into a single concatenated string value
  2. Bang Notation and Dot Notation in VBA and MS-Access
  3. “General error Unable to open registry key Temporary (volatile) …” from Access ODBC
  4. Is there a simple way of populating dropdown in this Access Database schema?
  5. How do I make a stored procedure in MS Access?
  6. How can I get table names from an MS Access Database?
  7. Is there any way to create multiple insert statements in a ms-access query?
  8. Running Microsoft Access as a Scheduled Task
  9. How to diagnose MS access crashes
  10. “Operation must use an updateable query” error in MS Access
  11. VBScript & Access MDB – 800A0E7A – “Provider cannot be found. It may not be properly installed”
  12. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  13. MS Access LIMIT X, Y
  14. Prevent enabling of shift bypass – Access 2010
  15. Access 2007 – Left Join to a query returns #Error instead of Null
  16. Access query producing results like ROW_NUMBER() in T-SQL
  17. Pivot Query in MS Access
  18. Is MS Access (JET) suitable for multiuser access?
  19. Save password for ODBC connection to MS SQL server from MS Access 2007
  20. How to write Case Sensitive Query for MS Access?
  21. Setting up an MS-Access DB for multi-user access
  22. Access VBA: Find max number in column and add 1
  23. ConcatRelated function in a query
  24. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  25. Create sequential ID value based on the year that a record is added
  26. How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?
  27. Null values for variables in VBA
  28. MS Access query returning Chinese characters – possible table corruption?
  29. Using a centralized VBA module in multiple Access databases
  30. How to add a menu item to the default right click context menu

Leave a Comment