Reset identity column in MS access database

Question

Currently i am trying to reset an identity column in my MS access database by using following command but it is not working.

DBCC CHECKIDENT('my_table', RESEED, 1)

Error Message :

Invalid SQL Statement ; expected "Delete","insert","procedure","select" or "update"

How to fix it ?

score 2 · Accepted Answer · edited May 23 '17 at 11:49

2

CHECKIDENT works on SQL Server only. Here is a link to an explanation how to do it in Access: How to restart counting from 1 after erasing table in MS Access?

edited May 23 '17 at 11:49

Community

answered Jul 20 '13 at 15:10

Luke Wage

1 Answers1