Quick Question - ADO in Access 97?

  • Thread starter Thread starter Leah
  • Start date Start date
L

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
 
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.
 
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
 
The differences between ADO and DAO are pretty small. I can't imagine that
the code would have to be altered very much.
 
Leah said:
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.
Click to expand...

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
 
Back
Top