upgrading from Access 97 to Access 2000 2

[koz]

I've got several applications written using VB6 SP5 and Access 97. My PC was upgraded to Access 2000 when they upgraded it to Office 2000.

My programs still work but I can't use Access 2000 to make changes to the Access 97 database objects now. I'd like to have that option available for emergency's.

I am trying to change my programs to access the Access 2000 databases but when I try to create a recordset I get errors.

When I installed SP5 there was a note that I might need to install mdac 2.6 so when I started having problems I installed the SDK 2.6 from Microsoft's site.

What do I need to do to access my converted to Access 2000 databases?

 

[SIG357]

I think there's something screwy with how DAO handles 97 db's and 2000 db's. If you are using DAO, try the stuff with ADO and see if that works.

 

[koz]

How do I easily convert, DAO is all I know.

 

[TheInsider]

In short: Access 97 uses DAO and Access 2000, by default, uses ADO. DAO is now obsolete, however, you can simply add the DAO reference to your VBA code in Access 2000. By adding the Microsoft DAO 3.6 Object Library, you can continue to use DAO in Access 2000. Note: You should be using version 3.6 with Access 2000, not version 3.51.
Rob Marriott
rob@career-connections.net

 

[Rohdem]

Rob is exactly right, but make sure that your DAO reference has a higher priority than the ADO. Mike Rohde
rohdem@marshallengines.com
"If builders built buildings the way programmers wrote programs, the first woodpecker to come along would destroy civilization!"