ADO Error: Automation error – The specified module could not be found

adovb6

My VB6 application which runs successfully on many machines is producing the above error on just 1 users machine. Machine has Vista SP1 which means the MDAC installer will not work since MDAC 2.8 is already included.

Code that leads up to the error:

'Temp file to users temp directory:
FileName = C:\DOCUME~1\nmiller\LOCALS~1\Temp\TmpPrint.mdb 

Dim catADO As New ADOX.Catalog
catADO.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & FileName

Error happens on the .Create line.

Any help getting this user going would be greatly appreciated!

Best Answer

Is there a permission problem with the file? Perhaps on Vista, you need to grant permission on the file. We know that Vista has much tighter security, including file and folder access.