Kbase P20583: ODBC Driver error - Lock Table overflow using Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/08/2004 |
|
Status: Unverified
SYMPTOM(s):
Receives ODBC Driver error when extracting information from Progress into Access
ODBC call failed - Data Direct ODBC driver - lock table is full.
Database log file has 915 error at same time as ODBC driver error
Lock table overflow, increase -L on server (915)
promon indicates that Lock Table High Water Mark has been reached
Using Access make-table query statement which copies data from one table into another table in Access
CAUSE:
Accesses make-table query locks all records in the table that it is copying. This combined with any other locking activity occurring on the database results in lock table being exceeded.
FIX:
Increase -L parameter on Database Server startup to accommodate increased number of records being locked as a result of the make-table query statement.