Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
DAO and ADO
We have several (older) applications developped with access97 using DAO.
We are planning to install access2000.
Does anyone know whether these older applications will still run ? Do we have to do any conversions ?
We are planning to install access2000.
Does anyone know whether these older applications will still run ? Do we have to do any conversions ?
Who is Participating?
Hi,
If you've converted any DAO code from Access 97 to Access 2000, you
may have run into trouble with the Database and Recordset object
types, because they've both been replaced in ADO. That means the
simple statements
Dim dbs As Database
Dim rst As Recordset
would both return errors if you try to run them in Access 2000.
You must use these statements:
Dim dbs As DAO.Connection
Dim rst As New DAO.Recordset
You should reference a DAO library : choose
Tools, References; select a Microsoft DAO Object Library; and then
click OK. Once you reference the correct library, the module will work
with the DAO object references Database and Recordset.
Regards
If you've converted any DAO code from Access 97 to Access 2000, you
may have run into trouble with the Database and Recordset object
types, because they've both been replaced in ADO. That means the
simple statements
Dim dbs As Database
Dim rst As Recordset
would both return errors if you try to run them in Access 2000.
You must use these statements:
Dim dbs As DAO.Connection
Dim rst As New DAO.Recordset
You should reference a DAO library : choose
Tools, References; select a Microsoft DAO Object Library; and then
click OK. Once you reference the correct library, the module will work
with the DAO object references Database and Recordset.
Regards
I receive the tipworld newsletter too !!!!!
What I don't understand is : do you have to convert your vb-sources ? Once you have installed access2000, do the older .exe's still run ????
What I don't understand is : do you have to convert your vb-sources ? Once you have installed access2000, do the older .exe's still run ????
You will need to change the DAO library reference from DAO 3.5 to DAO 3.6.
The point about ADO is true but *ONLY* if you start putting in ADO references. If you have a purely DAO project at present this is a red herring!
The DAO 3.5 library will NOT read/write access 2000 databases, if you change to the DAO 3.6 library which is available from microsoft as a download then you can without changing anything else in the code as far as I am aware.
The point about ADO is true but *ONLY* if you start putting in ADO references. If you have a purely DAO project at present this is a red herring!
The DAO 3.5 library will NOT read/write access 2000 databases, if you change to the DAO 3.6 library which is available from microsoft as a download then you can without changing anything else in the code as far as I am aware.
Thanks TimCottee
So all i have to do is :
download dao 3.6
reference this in the vb application
remake the .exe
redistribute my applic
?
Can I already use the DAO 3.6 with access97?
So all i have to do is :
download dao 3.6
reference this in the vb application
remake the .exe
redistribute my applic
?
Can I already use the DAO 3.6 with access97?
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
DAO 3.6 should be fine for Access97 as well.