Re: vb6 access 97 to 2003 upgrade

You have a smorgasbord of libraries, complete with multiple redundancies and
some questionable versions mixed in. The Access 2003 project doesn't list an
Excel library - which should be Microsoft Excel 11.0 Object Library to match
the version of Access. *If* your project needs spreadsheet functions. Does
it?

Chris
Microsoft MVP


mrteech@xxxxxxxxx wrote:
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

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vbasic/200809/1

.

Relevant Pages