Board index » delphi » ????? ACCESS Autonumber error, adds more then 1 ??????
Sun, 29 Apr 2001 03:00:00 GMT
????? ACCESS Autonumber error, adds more then 1 ??????
I am using Delphi 4, BDE 5.01 with the native ACCESS driver. Ok no
Then I tried to add a record to a table who's prim. key is of the
autonumber type, it adds the key but leaves holes in it, it doesn't add
1, but 2 or 3. e.g. Last record id=3, add a new one, the ID will be 5 or
6 and not 4.
While with an other table all goes well, no holes in my prim. key
Now I also tried the ODBC version, and all goes well, no problems with
I also found an other difference between the native and the ODBC version.
Does anybody know what's wrong?????
Maybe a usefull tip, Indexes wont work if you have spaces in an attribute
Ido de Lepper