VB6 + Acces 97 + Jet 3.51 - errors when distributed.
Posted on 2007-03-25
I have a problem with Microsoft VB 6 with an application I have written for resale. It uses an Access 97 database and Jet 3.51 which I am happy with.
The program once compiled works fine on the machine I work on, but when I deploy it (using Innoscript) and it is downloaded on new PC's, the program falls over at the following line...
datStaff.RecordSource = "Select * from [C:\Program Files\directory].[staff]"
... I thought I had fixed the problem by packaging MDAC_TYP.EXE with the software, as this seemed to work on a clean installation.
However, if you try to re-install again, it comes up with "Microsoft MDAC 2.5 is already located on this Windows machine...." etc
I am at my wits end now - it's really urgent I get this sorted - has anyone come across this problem before and knows how to solve it ?