I am getting error "80004005 Could Not Find File"

[dereski]

Hey all,

I am trying to connect to my database but I am getting error "80004005 Could Not Find File" Any Ideas as to why? I tried recreating the database again, just in case it was corrupted but same result. I am using VBA

Set MyConn = New ADODB.Connection
MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=N:\new parcel\WawaDogs;"

'Open the connection
MyConn.Open

'Create a ADO recordset that will contain data from access table
Set MyRecSet = MyConn.Execute("SELECT * WawaDogs")

Cheers

 

[PHV]

Have a look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886