ASP & Access - Errors
- Error: Microsoft JET Database Engine (0x80004005) Unspecified
error
- Error - dies on the .Open() of the ADODB.Connection
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
- Suggested Solutions (Win 2000, maybe others)
- Permissions for the following users:
IUSR_<machineName>
(Note: I don't think you need to do anything with this user: IWAM_<machineName>)
(Using Explorer, right click on directory/file then click the
Security tab.)
- Directory User Permissions for the Temp directories.
- Control Panel, System, Advanced, Environment Variables.
Make sure that you look for "TEMP" or "TMP" in both the
"User variables" & "System variables".
- First, try all but "Full Control" & "Modify"
- <filename>.mdb - user permissions - play with the
permissions of the file and the directory.
- MDAC version - update if needed.
- Determine current version: (as of 12/18/07 for Win 2000 &
XP)
Start, run, regedit
HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess
FullInstallVer - 2.81.1128.0
Version - 2.81.1117.6
-
http://www.microsoft.com/downloads - locate updates if
needed.
- Access Jet 4.0 version - update if needed.
- Determine current version: (as of 12/18/07 for Win 2000 &
XP)
Locate: Msjet40.dll
ex: C:\WINNT\system32\msjet40.dll
Right-click the Msjet40.dll, then click Properties.
Click the Version tab, and then use the following table to
determine the current Jet 4.0 service pack level:
ex on 12/18/07: Product Version: 4.00.8618.0
- Register the Jet 4.0 DLLs again. I'd repeat this after
installing MDAC and/or Access Jet 4.0.
(Note: I would create a batch file for this).
C:\WINNT\System32\regsvr32 C:\WINNT\System32\Msjetoledb40.dll
C:\WINNT\System32\regsvr32 C:\WINNT\System32\Msjet40.dll
C:\WINNT\System32\regsvr32 C:\WINNT\System32\Mswstr10.dll
C:\WINNT\System32\regsvr32 C:\WINNT\System32\Msjter40.dll
C:\WINNT\System32\regsvr32 C:\WINNT\System32\Msjint40.dll