Resetting AutoNumbers

[Guest]

Re. the advice (of 12/23/04) from Allen Browne, on Access 2000 + up; because
I am not d/b literate, I just want to make sure that I am about to do the
correct thing.

I did make a copy of my d/b. From the db window >Modules >New, you write
that Access opens a new code window. The window I get shows a heading of
"Module 1 (Code)", and drop-down menus labelled "General" and "Declarations",
and within the dialog area (is this the "code window"?), the words "Option
Compare Database" appear. Do I just copy/paste "? AutoNumFix( )" beside
that? Below that? ("that", being the words "Option Compare Database")

And then, after doing this I go to Tools, >References, and check the box
"Microsoft ADO Ext. 2.x for DDL and Security", >Debug >Compile; Press Ctrl+G
to open the Immediate Window, and enter the code "? AutoNumFix( )" again
(without the quote marks)?

Thanks again everyone for all the help.

 

[Allen Browne]

Presumably you are talking about this link:
http://members.iinet.net.au/~allenbrowne/ser-40.html

Yes, paste the code below the Option Compare ... line.

When you add the references, the "2.x" will appear as "2.7" or some other
number.

When you press enter after the "? AutoNumFix( )" in the immediate window,
you will receive a message box asking for confirmation about each table that
it thinks needs changing.