Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File Sharing Lock Count error, any ideas?

Status
Not open for further replies.
PantoKing

PantoKing

Technical User
Nov 28, 2001
169
GB
Hello,

I am getting the following error message:-

"File Sharing Lock Count Exceeded, Increase MaxLocksPerFile registry entry."

This occurs when I am looping through records in a recordset and updating the value.

This bit of code used to work perfectly in Access 97 but since I have converted to Access 2000 I am getting this error.

Has anyone get any ideas on how to solve this.

Cheers,

Steve. Make things as simple as possible — but no simpler.
 
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Question
TransferSpreadsheet 3125 Error
Replies
5
Views
1K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
458
dhookom
dhookom
Moss100
  • Locked
  • Question
Find error in currency feild 2
Replies
8
Views
923
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
208
combo
combo
Kim296
  • Locked
  • Question
Sending Gmail using vba Send error
Replies
6
Views
989
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top