DAO Doesn't work after upgrade wizard

[MikeAngelastro]

Hi,

I just ran a complex app through the upsizing wizard. I discovered that the DAO code that used to work in Access as an mdb doesn't work in Access as an ADP. I hope I don't have to go around and modify this code to use ADO. If this is needed, why didn't the wizard do it?

Any ideas?

Mike

 

[Mile-O]

OPen a module, goto Tools -> References

Ensure that Microsoft Data Access Objects 3.5 or 3.6 is selected.

Change the priority of this library to be above Microsoft ActiveX Data Objects library

 

[MikeAngelastro]

Thanks Mile-O-Phile,

DAO 3.6 is checked and is above ADO in the references list. I had checked this before and it was set up. But it still didn't work. Any other ideas?

Thanks again,

Mike

 

[Mile-O]

Are you putting:

Dim db As Database

or

Dim db as DAO.Database

 

[MikeAngelastro]

I'm using

Dim db as DAO.Database