"at end of table" error with BDE/Access

Posted on 2003-03-14
Medium Priority
Last Modified: 2013-11-23
Hi guys.
I'm writing an app that connects to Access via BDE. This is access 97, I'm using Delphi 5, and the computer is windows 2000 using office XP (Maybe that's where the problem is). I couldn't convert the DB to access XP or access 2000 because then the BDE won't connect to it (maybe there are new drivers or something?).

Anyway, I have a master-detail tables (2 tables). When I add a record to the master table, it works fine. If I add a record to the detail table, I get a 'At end of table' error after the POST command. I checked a 1000 times that all values in all fields in the table is correct (including the primary-key, I simply use a field called 'number' to diffrentiate).

What am I doing wrong???


Question by:ShadowHawk071998
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

Accepted Solution

Stefaan earned 2000 total points
ID: 8134730

First of all, if you are using Access I would strongly reccomend you to go with ADO instead of BDE.  BDE Requires you to install the BDE on the client machine, where ADO is already installed with Windows 2000, Windows XP and is even installed with Office.

I think it will be much easier to access you Aceess DB using ADO than it is with BDE.

Best regards,

LVL 17

Expert Comment

ID: 8134755
Hi Ron,

As far as I know BDE can't work with Access2000 and later. You have to use alternatives if you want to migrate to newer Access version (like ADO components).

About the error:
Where does the error occur? On executing POST command or after?
What do you have after POST?
Have you tried your app outside IDE?

Regards, Geo

Author Comment

ID: 8146810
Is moving to ADO easy? I have delphi enterprise so it should be included, right? I'll give it a try.

I haven't tried the app outside IDE. And after POST I do nothing (but get the error)...

Maybe it is the Access 2000 - Nothing like that ever happened in Access 97! progress is not so good a thing ;-)


Expert Comment

ID: 9316785
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
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…
Suggested Courses

764 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