Original address:
NEURAL.CS.NTHU.EDU.TW/JANG/COURS/CS3431/student/accesserrorq_916718/
=======================================
Asp's MS Access Database FAQ Common Error Message Meeting Table (ASP Microsoft Access Database Errors FAQ's)
=======================================
Error code unrecognizable database
Chinese version: [Microsoft] [ODBC Microsoft Access Driver] Unable to update. The database or object is only read.
English version: Can not update Database or object is read-only Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft] [ODBC Microsoft Access Driver] Can not update Database or object is read-only....
Because the user tries to add or update the action, the error message will appear when there is no sufficient permissions. Solution is to modify the information sheet privilege, and it is possible to be the server-side database is open, thus causing unrecognizable The situation is required to close the data before you can add or update the information.
The setting method is as follows:
1. Click Access data table => Press Right click ==> Security Options (Security) =>
Click the Add (Add) button
2. Then I will
Iuser adds to the allowed list
3. In the properties window, check
Allow read and write permissions, (all check can also be) as shown below, then click OK to complete the setting.
-------------------------------------------------- --------------------
Error code parameter is too small
Chinese version: Microsoft OLE DB Provider for ODBC Drivers Error '80040E10' [Microsoft] [ODBC Microsoft Access Driver] is too small, and the expected number 1 is expected.
English: Microsoft Ole DB Provider for ODBC Drivers (0x80040E10) [Microsoft] [ODBC Microsoft Access Driver] TOO FEW Parameters. Expected 1.
The reason for this type of error is that the SQL instruction may have an error. For example: the name of the field in the SQL instruction may not do with the column name in the entity data table, so the solution is the SQL conditional operation in the reciprocating code. There is a status of tangle words.
-------------------------------------------------- --------------------
Error code BOF EOF problem
Chinese version: Adodb.field (0x800A0BCD) may be the value of Bof or EOF is true, or the current record has been deleted. The required operation requires the current record
English: adodb.recordset (0x800A0BCD) Either Bof or EOF IS TRUE, or The Current Record Has Been Deleted. Requested Operation Requires A CURRENT RECORD. This type is a problem with the data set. This problem occurs. Generally, the user sends a query condition, but the result of the feedback is empty, that is, the information that does not meet the query conditions. The solution is the setting of the setup of the query condition and the replan setting, determine when the query condition is transmitted. Not an empty information.
-------------------------------------------------- --------------------
Error code operation must use update query
Chinese: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft] [ODBC Microsoft Access Driver] Works must be used Update query
English: Microsoft Ole DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Microsoft Access Driver] Operation Must Use An Updateable Query.
Because the user tries to add or update the information, the error message will appear when there is not enough permissions. Solution is to modify the information sheet authority,
Set the same way
-------------------------------------------------- --------------------
Error code Unable to turn on the login key
Chinese: [Microsoft] [ODBC Microsoft Access Driver] General Error Unable to turn on the login button 'Temporary (Volatile) Jet DSN for process 0x898 thread 0x914 dbc 0x209e024 jet'
ENGLISH: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft] [ODBC Microsoft Access Driver] General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x6cc Thread 0x78c DBC 0x144cfc4 Jet'.
This problem may have many reasons, the most common situation is incorrect, so it is necessary to check if the setting of the database path in the file is correct. In addition, IIS's permissions will also affect, need to check Is the iUser have access rights, and the permissions for iUser can be referred to the example
Set the same way
-------------------------------------------------- --------------------
Error code can't find a file
English: Microsoft Jet Database Engine (0x80004005) COULD NOT FIND FILE 'C: /INETPUB/wwwroot/databaseName.mdb'.
The reason for this type of error is that the setting error of the data table path is not found to find the corresponding database specified in the ASP file. Solution is whether the path setting of the reciprocation data sheet is correct.
-------------------------------------------------- --------------------
Error code data table is locked
Microsoft Jet Database Engine Error '80004005' Table 'TBLTABLE' IS EXCLUSIVELY LOCKED BY User 'Admin' on Machine 'MyMachine'. The reason for this type of error is that the data sheet cannot be accessed or the information list is currently 'design inspection. " State. Solution The design view window in Access is closed, and the data table is not in the design inspection state.
-------------------------------------------------- --------------------
Error code file is in use
Microsoft OLE DB Provider for ODBC Drivers Error '80004005' [Microsoft] [ODBC Microsoft Access Driver] Could Not Use '(unknown)'; file already in use.
The reason for this type of error is likely to set an error due to the permissions of the database, and the version of the Microsoft Data Access Components is wrong. Please confirm that the installed ODBC version is more than 4, and the version is available.
ODBC version information
