AdoQuery and Access

[yomyom]

Hi,
I've been trying to load an AdoQuery with an SQL statement -a simple one e.g select * from invoice -.
Invoice is the table in the abase Database which is an ms access database loacated on my machine.
When I use adoTable it connects but when I use Adoquery I get an error message saying jet4.0 cannot connect to the table etc.
Can anyone solve this 4 me?
Thanks in advance.
Yomi.

 

[yomyom]

Hello all,
It appearsthat the word transaction may be a reserved word because whem I changed the accesstable's name to myTransaction, the connection was made.
Yomi.