VB App using Access w/o Access on Install Machine
Posted on 2001-06-09
I am developing a project (VB6, sp5) using ADO and Access. My understanding is: as long as I do not use OLE Automation of Access in the VB app and just use it to obtain and write data to the db, then the install machine need not have Access installed on it. Just distribute MDAC and all is fine...True?
Things I have tried -
-there is a provider installed (checked in the reg by HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\MS Access Driver (*.mdb)
-checked references and not using OLE Automation or the Access Object Library (and both are unchecked)
During install I am getting on error "Failed to load resource DLL on OLED32R.DLL, therefore the initialization fails and it cannot register it either. Hand reg doesn't work with this DLL, but it must be distrib thru MDAC (although it is not listed in the MDAC distrib white paper). But I am not convinced this is the entire problem.
Do I need to buy Microsoft Office Developer Edition? What will this do for me? Too, MS is only selling 2000 for this product and I need Access 97.
HELP, I need a solution soon!!!
Thanks for your comments! I am still having issues making this work. The install package was made using PDW wizard and is going onto an NT machine (so DCOM not required). OLED32R.DLL is not listed in the lst file, nor is it on the development machine - that's why I thought it may be something related to MDAC. I did install MDAC manually when this error occurred ensuring it did actually install. The version number under the sys is 2.50.4403.12, same as the one delivered with SP5. Hmmm...