ADO conversion

[knowledge76]

I have converted a databse from access 97 to access 2002, now the prob is that access 2002 use ADO as default and access 97 dao as default and i wanna convert DAO to ADO. But even then some of DAO is still required in some way. Can DAO and ADO work parellely ?
I have to then transfer my backend to sqlserver and frontend to access. would the mutual working of DAO and ADO cause problem in these two phases?

 

[jgc31]

Surely all you have to do is include the reference to the DAO library and then all the DAO stuff will work properly. I have DAO code working perfectly OK under 2003.

 

[jgc31]

This recent thread has details

http://www.access-programmers.co.uk/forums/showthread.php?t=80918

 

[knowledge76]

But is the mixture of dao and ado not dangerous if in the future DAO would fade out?
if i use dao library in access 2002, will i have to use ODBC or OLE DB for the connection between sql server?

 

[jgc31]

as long as you explicitily declare that you wish to use a dao function should be OK eg dim rsTest as DAO.recordset ( this is good practice anyway). As to the future search the site and you will find discussions on this topic by those far better informed than I . I believe that you can run DAO and ADO in parallel although I have never tried again there are a number of threads on this topic if you search for them.

 

[jgc31]

For lots of info on this subject check out

http://search.microsoft.com/search/results.aspx?qu=dao+to+ado&View=msdn&st=b&c=4&s=1&swc=4

 

[knowledge76]

thanks a lot i hope this all stuff will help me a lot