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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

717 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