I have a worksheet that obtains its data from an Access database. I am
trying to convert from DAO to ADO but am now getting errors when tring to
open a recordset that worked perfectly well in DAO. I am using
TRANSFORM.....SELECT in the SQL to open the recordset, can I do this using
ADO?
TIA
Mark

ADO just serves to "feed" your SQL commands to your
database, so as long as you have set up the connection and
recordset properly, and written your query properly in
SQL, it should work. But hard to troubleshoot without
knowing the details of your query and the error message
you are getting.

-----Original Message-----
I have a worksheet that obtains its data from an Access
database. I am
trying to convert from DAO to ADO but am now getting
errors when tring to
open a recordset that worked perfectly well in DAO. I am
using
TRANSFORM.....SELECT in the SQL to open the recordset,
can I do this using
ADO?
TIA
Mark
.

Thanks for the reply. I had another good look at the SQL and I was using a
reserved word that ADO did not like, but was acceptable to DAO - so problem
resolved by putting square brackets around the reserved word.
Thanks again

Mark

"K Dales" wrote:

ADO just serves to "feed" your SQL commands to your
database, so as long as you have set up the connection and
recordset properly, and written your query properly in
SQL, it should work. But hard to troubleshoot without
knowing the details of your query and the error message
you are getting.

-----Original Message-----
I have a worksheet that obtains its data from an Access
database. I am
trying to convert from DAO to ADO but am now getting
errors when tring to
open a recordset that worked perfectly well in DAO. I am
using
TRANSFORM.....SELECT in the SQL to open the recordset,
can I do this using
ADO?
TIA
Mark
.