I have a DBGrid and ADODC connected to an two tables on an Access DB on a Novell server. One table has about 10,000 records and the other around 150,000. Access can run the query in under a minute, but with ADODC the program appears to lock up and takes over five minutes to retrieve just 30-50 records.

I have seen other posts about similar problems but no one seems to know the solution. Has anyone a CLUE as to how to speed up ADO?

Thanks in advance,

Andrew