Error "3050 Could Not Lock File"

[HappyFace188]

Recently I have re-develop an in house VB6 application using access database. The executiable program is on the users' local machine and the database is on NT server. Users have been getting error 3050 while they are reading or writing to the database which did not happen previously. The only material on this topic that I can find from the MSDN is to change the MaxLocksPerFile to 128 in its sample code. It did not help. Can anyone tells me what might cause the problem and possible solution? Thanks so much.

 

[mac318]

This type of error most often occurs when you are running a transaction which must lock the table before it can run. VB6 may have resent until the table became available (no one accessing data); however, Access sent the error code back to you and is waiting for instructions on how to manage the error condition; i.e., wait and retry or quit.

mac