Quote:
microsoft ole db provider for odbc drivers error '80004005'
[microsoft][odbc microsoft access driver] could not use '(unknown)'; file already in use.
|
A reason for this error is that you have the database already open in MS Access or by another program. Close the other program you have the Access database open in and try again.
It usually due to either incorrect permissions are set on the server or the incorrect version of MDAC.
You need to ensure the ODBC version you have is 4 or greater.
Quote:
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 error commonly occurs when the path to the database is incorrect.
You need to check that the path to the database is correct. You must use the physical path on the server to the database and not a virtual path.
The error also occurs if the permissions on server are incorrect. Check that IIS has sufficient permissions to access the registry, read and write permissions are set on the directory containing the database and the database itself, for the IUSR account.
Quote:
Microsoft JET Database Engine (0x80004005)
Could not find file 'X:\Inetpub\vhosts\DomainName\db.mdb'.
|
This error occurs when the database file can not be found, that means when the path to the database is incorrect. Check if database path is correct or not.
You must use the physical path on the server to the database and not a virtual path.
Quote:
Microsoft JET Database Engine error '80004005'
Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'.
|
This error means that you are either unable to open the table or you already have the table open in Microsoft Access. Close the Access and try again.
Quote:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted.
|
This is a error related to recordset. It means that you have tried to read a record from the recordset that has either been deleted or does not exist.
Most commonly this error occurs if you have run a database query that has not returned any records and you have then tried to read in a record from the recordset that contains no data.
You need to first check that there is a record in the recordset before reading it in.
Quote:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
|
This error occurs when one of the field used in a select statement does not exist in the table being queried.
Check that your query is correct and you have not misspelled any of the field names in your select statement and that the field name exists in the table being queried.
Quote:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
|
This is a recordset related error occurs when you tried requesting a field from the recordset that does not exist.
Check when you are reading in the field from the recordset that you have spelt the field name correctly and that the field exists in the database.