Visual Basic Q&A

Symptoms
You have a Visual Basic ActiveX DLL that has a method that takes an array of Scripting Dictionary Objects as an argument. It may work fine when your Visual Basic client is run in the Visual Basic integrated development environment (IDE) by using this method, but when you run it as a compiled application, you get the following run-time error message:

Run-time error ‘-2147417848 (80010108)’:
Method ‘~’ of object ‘~’ failedThis only occurs when you use late binding to call the method.
Resolution
Use early binding to work around the problem.

Symptoms
If you use the Visual Basic Data Form Wizard to open an Access 2000 database you may get the following error:

“Unrecognized Database Format ‘….\your_database_name.mdb’”
Resolution
The Visual Basic Data Form Wizard uses the Jet OLEDB 3.5 Provider which does not recognize the Access 2000 database format.