Quick Question - ADO in Access 97?

[Leah]

I have to down grade to fit the customer's environment. Can I use ADO
2.whatever in Access 97? Or should I go back to DAO?

Thanks for answers!


Leah

 

[Douglas J Steele]

Use it how?

I use ADO against SQL Server from Access 97 with no problems. However, I
don't feel it makes sense to use ADO against Jet databases (i.e. MDBs) in
any version.

 

[Leah]

I had an existing 2000 app that used recursion from one recordset to
populate a hierarchical view.

In DAO, this seems to be a bit of a challenge. I didn't write this code, so
I was just tasked to see if it could be done. And my DAO is rusty.

Just now, the decision has been made to strongly encourage the client to
upgrade to at least Access 2000. Saves me a lot of hassle.


Leah

 

[Douglas J. Steele]

The differences between ADO and DAO are pretty small. I can't imagine that
the code would have to be altered very much.

 

[TC]

I had an existing 2000 app that used recursion from one recordset to
populate a hierarchical view. In DAO, this seems to be a bit of a challenge.

Not really. I do it in one of my apps. It's just a straight recursive
procedure. It really doesn't make any difference what the data access
method is.

HTH,
TC (MVP Access)
http://tc2.atspace.com