[RESOLVED] How difficult would it be...

[dewfiend]

to convert a program to use ADO?

Background: I inherited a project (VB6 with SP6) that hasn't had a new release in about 6 or 7 years. It currently uses DAO and I made it compatible with Access versions up to 2003. However, I would like for the program to be compatible with at least Access 2007. I am a newbie to VB6.

I appreciate any help

[Hack]

Welcome to the forums

How difficult it would be is directly proportional to how well you know ADO.

If you know it well, then the difficutly factor is diminished.

However, if it is a large project, it will be time consuming. I'm migrated projects from DAO to ADO before (years ago). You will be surprised at the number of data object (DAO or ADO) calls make in an average project.

In a large one....phew. Takes a while...

[dewfiend]

Thanks

Like I said, I'm a newbie, so not very well unfortunately. But I'm very willing to learn.

Right now, we don't have a specific date for this to be completed and it's a decent sized program (large to me). Am I safe to assume that it will be worth while to do if we stay with VB6 and want to keep up with the Microsoft Access versions (as much as we can anyways)?

[dewfiend]

Also, any suggestions on references I could/should use for the syntax?

[si_the_geek]

There are several examples (and a tutorial) in the "Classic VB: ADO" section of our Database Development FAQs/Tutorials (at the top of the Database Development forum)