Who's code?

Just reading this would deter me from using databases i dont know how you made sense of all this.

Perhaps your problem is in your recordset line with the SQL statement. I.e your using adcmdTable instead of adcmdtext or something.

One thing DAO is good but MS aint gonna be supporting it in the future as far as i know. Frankly if you use ADODB correctly then it would be hard to detect the difference in speed.
I have several huge db's at work some in SQL some in access and i cant notice much difference between dao and ado i even tested a 1.5gb access db 1 prog used dao and 1 used ado and there was little to no difference.

I couldnt put up with using text files that must take so long and be so annoying. Plus they be huge and lots of coding.

later
b