Autoincremental fields in Access 97 with D4 & BDE

Posted on 1999-01-05
Last Modified: 2010-05-18
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.
Question by:DeanSmith
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Author Comment

ID: 1354639
I have an access 97 database that I am using the BDE to access. Everything
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.
LVL 17

Expert Comment

ID: 1354640
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

LVL 17

Accepted Solution

inthe earned 50 total points
ID: 1354641
That should be common problem with "bde" and is documented in the Delphi 3 readme.txt file the only solutions are either remove the autoincrement field and use a number or remove all the default values from fields
Regards Barry


Author Comment

ID: 1354642
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.
LVL 17

Expert Comment

ID: 1354643
you guess correct it is problem with bde as you say
Regards Barry

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question