A2007 not supporting dao

[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

 

[Douglas J. Steele]

Exactly what was the message? DAO is alive and well in Access 2007.

 

[JohnE]

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

.... John

 

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

 

[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