vb6 access 97 to 2003 upgrade

[mrteech]

hello I have a VB6 project which currently accesses a Access 97
database. I now need to upgrade to access 2003 (yeah I know we're
behind and I am upgrading to c# later - this is an intermediate step)

the project references when using access 97 were:
Microsoft DAO 3.51 Object Library
Microsoft ActiveX Data Objects 2.5 Library
Microsoft Excel 11.0 Object Library

the project references when using access 2003 are:
DAO360.DLL#Microsoft DAO 3.6 Object Library
Microsoft ActiveX Data Objects 2.7 Library
Microsoft ActiveX Data Objects Recordset 2.8 Library (I checked
Recordset 2.7 Library but 2.8 appears)
I also tried just keeping Microsoft ActiveX Data Objects 2.5 Library

I develop on XP and the prod box is windows 2003. Access 2003 has
been installed on both boxes. The project compiles and runs fine in
dev. It just "hangs" immediately when run in production. no message,
I can't write to a file in the 1st step. so I assume an invaild
reference is being made, but I'm just guessing. can anyone help me
figure out how to determine and fix the problem? thanks

 

[Auric__]

hello I have a VB6 project which currently accesses a Access 97
database. I now need to upgrade to access 2003 (yeah I know we're
behind and I am upgrading to c# later - this is an intermediate step)

Actually, for non-.Net stuff, you're in the right place.

I develop on XP and the prod box is windows 2003. Access 2003 has
been installed on both boxes. The project compiles and runs fine in
dev. It just "hangs" immediately when run in production. no message,
I can't write to a file in the 1st step. so I assume an invaild
reference is being made, but I'm just guessing. can anyone help me
figure out how to determine and fix the problem? thanks

I'd suggest looking through the microsoft.public.office.developer.* heirarchy
for a better group than this one.

 

[mrteech]

thank you for this very good explantion. I will follow you advice and
let you know the results.