DeanSmith
asked on
Autoincremental fields in Access 97 with D4 & BDE
My autoincremental fields are not incremental by 1 but by a random number. is there a setting which tell the bde to increment in this manner.
This is common problem with access when you have default values together on the same table. Remove the default values and the Autoincrement feature will work.
Regards Barry
Regards Barry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Default values on the field in the access table seem to increase the autoincrement number by 1 more than the number of defaults.
If anyone has a reason for this i would like to know as I think it must be a fundemental problem with the BDE.
If anyone has a reason for this i would like to know as I think it must be a fundemental problem with the BDE.
you guess correct it is problem with bde as you say
Regards Barry
Regards Barry
ASKER
works fine except for the autoincrement field. It produces random results
rather than a sequential increment. On one machine it increments by 5 and on
another it is 6. I tried reinstalling BDE and that did not help.
I am using the most current, 5.0, that came with Delphi 4.0. I have installed update patch 2. If anyone can offer an assistance I would greatly appreciateit.