<div>
If this is a access db, only way I know how to reset autonumber is to empty table then do a compact/repair.<br />
<br />
Is this backend msacceess or some other db
</div>


If this is a access db, only way I know how to reset autonumber is to empty table then do a compact/repair.

Is this backend msacceess or some other db

<div>
ok, your sql will work but unless the table is empty, you run the risk of failing records due to duplicate records<br />
<br />
as you cant do this on linked tables, only other way I can think of is if you open the access database via vba then run the sql<br />
<br />
<br />
<br />

</div>


ok, your sql will work but unless the table is empty, you run the risk of failing records due to duplicate records

as you cant do this on linked tables, only other way I can think of is if you open the access database via vba then run the sql





<div>
<div class="content wysiwyg-content">
I have this:<br />
<br />
strSQL = &quot;ALTER TABLE Extracted_NDW_WEEKLY_PRODU<wbr />CT_MOVEMEN<wbr />T ALTER COLUMN [Auto_ID] COUNTER (10,1); &quot;<br />
CurrentDb.Execute (strSQL)<br />
<br />
Thanks
</div>
</div>


I have this:

strSQL = "ALTER TABLE Extracted_NDW_WEEKLY_PRODUCT_MOVEMENT ALTER COLUMN [Auto_ID] COUNTER (10,1); "
CurrentDb.Execute (strSQL)

Thanks

How can I reset autonumber of linked table?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.