I have been trying to set up a client side script to connect to a local-user database. Seems pretty simple right? Here is my connection code:
Set dbConn = CreateObject("ADODB.Connection")
dbConn.Provider = "Microsoft.Jet.OLEDB.4.0"
dbConn.Properties("Data Source") = "C:\temp\Ppres.mdb"
dbConn.Open
The code above yields an error "The specified procedure could not be found." on the dbConn.open line. I'm using Win2000, MDAC 2.7, Jet 4.0 sp5, and IE v5.5. This should work!!
What am I missing here? Could Internet Explorer's Security settings be getting in the way? Is it some registry setting? Any advice would be appreciated.
Reply With Quote
