Link to home
Start Free TrialLog in
Avatar of Aliana Donovan
Aliana Donovan

asked on

Delphi Ado Query : Error Record is too large while trying to run ado query on Access database

I'm using Delphi 7 and ado query component to do inner join of three access tables (dump, dump_a, dump_b related by id as primary key). These three access tables have a lot of fields and some of the fields are text with character up to 100 even more.
I have tried to do update and post for each tables separately and having no error, it works fine.

Now, in my delphi project i have to (must) join the three tables based on their primary key by using (what i know best) a query.
But when i trying to run the query by doing inner join, it resulting a `Record Too Large`. here is the query :
select * 
from ((dump 
inner join dump_a on dump_a.id=dump.id)
inner join dump_b on dump_b.id=dump.id)
order by dump.id

Open in new window

I'm fully aware of the limitation of access database when update or post to never exceed 2k characters,
but i'm trying to do query here to join these three tables, i'm not trying to do update or post, why am i still got the `Record Too Large` error?
Is there any other approach, to join or combine the three tables without getting the `Record Too Large` error?
ASKER CERTIFIED SOLUTION
Avatar of jimyX
jimyX

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aliana Donovan
Aliana Donovan

ASKER

Nice idea to select only the needed field since i have so many field, i'm gonna go for it thank you.