A2007 not supporting dao

J

JohnE

I have an A2003 db that will need to run on A2007. Just tried it in test and
got the message that the dao code will need to be changed to ado. Has anyone
else run into this? Was it a big issue to convert over to ado? Does anyone
know of a way of changing the dao to ado that is not to time consuming? Have
a db that started out in A97 and is now in A2003. Also, during the
transition time of moving everyone over to A2007, some will still need to use
A2003. Has anyone had any difficulty with this?
Any help given here is appreciated.
Thanks.
.... John
 
J

JohnE

The message is "ODBCDirect is no longer supported. Rewrite the code to use
ADO instead of DAO."

.... John
 
D

Douglas J. Steele

Aah, that's very different. Presumably you're trying to get at data in some
other DBMS (SQL Server, Oracle, etc.). Yes, since ODBCDirect is no longer
supported, you can't use DAO in the same way you used to. It doesn't mean
that Access 2007 doesn't support DAO, though.

Unfortunately, there's no "silver bullet": no simple way to do the
conversion. You'll going to have to find every recordset in your application
and manually change the code. The differences between ADO and DAO are such
that you can't just do a simple Find and Replace. The only good news is that
you can use ADO from Access 2003 as well. (Hey, for that matter you can use
it in far earlier versions of Access!)

Good luck.
 
J

JohnE

Okay. Thanks for the info. Looks like the good news and bad news at the
same time. I was afraid that going to each rst would be needed. Now its
time to brush up on my ado.
.... John
 

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

just a general question 5
Conversion to A2007 7
authentication 3
Strange treeview behavior, A2007 0
An A2003 to A2007 security question 1
error message 1
using web services 2
going to Access 2007 1

Top