Re: Autonumbering failure after conversion from 2.0 to 2003

Autonumbering has never worked exactly right in Jet 4.0.
They added the ability to reset the Autonumber, and ever
since have been fixing bugs where the Autonumber reset
to the wrong value. Each bug they fix seems to create or
expose a new one. (And with the eminent release of Access
12, there is no reason to expect Jet 4.0 will ever work
correctly)

Here is Allen Brownes code to fix this common failure:

Fixing AutoNumbers when Access assigns negatives or duplicates
http://allenbrowne.com/ser-40.html

(david)

<knud.n@xxxxxxx> wrote in message
news:1135021927.799100.31450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello Everyone
>
> After converting my database from 2.0 to 2003 format, using the
> converter downloaded from microsofts homepage, all the fields that uses
> autonumbering does not work. Instedet of generating a correct
> incrementet number, the autonumbering generates a large negative
> number.
> Does anyone have any suggestions ???
> Any help is very much appreciated, thanks.
>


.

Loading