Marc, you can do an autonum update any time at all. You could add the autonum fixer to the startup routine easily.
SELECT MAX(PK+1) into vPK FROM table
autonum PK in TABLE USING .vPK



Marc wrote:
HI
We have a few users where the Autonum quits working for some reason.
My guess is dirty  power or user mistakes.
I have a House keeping form where I have a button that they can click to reset the Autonum but is there a way to check for this and fix it in a start
up routine?
Thanks
Marc


Reply via email to