Converting From DAO to ADO

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

retreive Access via ADO 2
to DAO, or not to DAO 2
Help With ADO 1
How do I add Microsoft DAO to the referenced lib in Excel 2003 1
DAO / ADO 11
Shared folder changed path - sometimes S://SharedFolder sometimes T://SharedFolder 8
Convert from DAO to ADO 7
DAO vs ADO 5

Back
Top