Microsoft JET Database Engine error '80040e4d'

schuh.mike · August 1st, 2006, 03:26 PM

I have tried EVERYTHING to figure out the problem I am having. Here is my connection:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data source=" & "D:\TimeReportDB\TimeReport.mdb;" &_
"Jet OLEDB:System Database=D:\TimeReportDB\Security.mdw;"

Set cnnTimesheet = Server.CreateObject("ADODB.Connection")

cnnTimesheet.Open strConn, "myUserName", "myPassword"

Currently it is telling me "Not a valid account name or password." I know i am using the correct username and password. I have also made sure that the IUSR account has read and write privelages. Could I get some help here?

Steven · November 26th, 2006, 06:30 PM

try this:

Code:

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
    "Data source=D:\TimeReportDB\TimeReport.mdb;" &_
    "Jet OLEDB:System Database=D:\TimeReportDB\Security.mdw;" & _
    "User Id=YourUserName;Password=YourPassword;

I am a loud man with a very large hat. This means I am in charge