Search Engine: Elastic
  • Article for your preferred language does not exist. Below is international version of the article.

Article ID: 120933, created on Apr 7, 2014, last review on Feb 7, 2018

  • Applies to:
  • Operations Automation 6.0

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")'
    

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0efe2234e2ce513f2186f26c68447702 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF