automation

[Eric W.]

I have a program that grabs emails with a specific
subject, saves the excel attachment to a folder, then
appends the data in the excel file to an access database
using automation. I keep receiving the error "Run-time
error '3706': Provider cannot be found. It may be
properly installed." The code it crashes on is below.
Any help is welcomed and appreciated. Any additional info
is available. Thanks in advance!!



strMDBFile = "g:\HASF\hasf.mdb"
Set myCONN = New ADODB.Connection
With myCONN
.Provider = "Microsoft.Jet.OLEDB.3.51"
.Mode = adModeReadWrite
'the error occurs on the line below
.Open strMDBFile, "admin", ""
End With

 

[Ken Slovak - [MVP - Outlook]]

You don't say which versions of Outlook, Excel and Access you are
using. Have you tried using this line:

..Provider = "Microsoft.Jet.OLEDB"

and leaving out the version for the driver?

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Lead Author, Professional Outlook 2000 Programming, Wrox Press
Lead Author, Beginning VB 6 Application Development, Wrox Press
Attachment Options
http://www.slovaktech.com/attachmentoptions.htm
Extended Reminders
http://www.slovaktech.com/extendedreminders.htm