[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Autoincremental fields in Access 97 with D4 & BDE

Posted on 1999-01-05
Medium Priority
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 200 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
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…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

656 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