Microsoft JET Database Engine error '80004005'

Created:

2016-11-16 13:11:16 UTC

Modified:

2017-04-24 11:22:15 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Microsoft JET Database Engine error '80004005'

Applicable to:

  • Plesk 11.0 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows
  • Plesk 9.x and below for Windows

Symptoms

ASP page interacting with MS Access database file ( '.mdb' ) displays the following error:

    Microsoft JET Database Engine error '80004005' 
Unspecified error

Or

    Objet Request error 'ASP 0104 : 80004005' Operation denied

Cause

  1. This is the permission issue in general.
  2. This is some misconfiguration in connection string

Resolution

  1. Check if IIS user has permissions to write in the directory, where database file is located and also has permissions to read, write and modify in the system '%TEMP%' directory.
  2. check the ConnectionString property of ADODB.Connection is one of the following 4 variants
    1. 'CN.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & Server.MapPath ("path_under_httpdocs\\access.mdb")'
    2. 'CN.ConnectionString = "Microsoft.ACE.OLEDB.12.0;Persist Security Info=False;DATA SOURCE=" & Server.MapPath ("path_under_httpdocs\\access.mdb")'
    3. 'CN.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & Server.MapPath ("path_under_httpdocs\\access.mdb")'
    4. 'CN.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};Uid=Admin;Pwd=;Dbq=" & Server.MapPath ("path_under_httpdocs\\access.mdb")'
Have more questions? Submit a request
Please sign in to leave a comment.