Reset Autonumber

[Melvin, Tom]

Hi All,

We've been testing a database, and we now want to use it. However, we'd like
to set the autonumber field back to 1. How do we do this?

 

[Joel Breen]

I use the following function which is quicker and has never failed to reset
the autonumber field. It exports (copies) table, structure only, to current
database with a new name and deletes the old table. I have a development
form which has a Command Button with code that passes the target table name
and calls this function. The function can be included in a module or as part
of the form's code.

Private Sub cmdResetTable_Click() 'Calls function
'Reset named table.

resetTable ("YourTableName")

End Sub

 

[Alick [MSFT]]

Hi,

There is an article addressing this problem, please click the link below:

Reset an AutoNumber Field Value in Access
http://support.microsoft.com/?id=812718

Please feel free to reply to the threads if you have any questions or
concerns.




Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.




--------------------
| From: "Melvin, Tom" <[email protected]>
| Subject: Reset Autonumber
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hi All,
|
| We've been testing a database, and we now want to use it. However, we'd
like
| to set the autonumber field back to 1. How do we do this?
|
|
|