File Sharing lock count exceeded

[williamlove]

Occasionally after editing multiple forms I hit save and after a long wait the save fails and I get a nasty message about File Sharing lock count exceeded. When this happens some or all of my forms and tables dissappear until I close Access and reopen it (and one horrible time my database was ruined but I had backup that was only a days work behind).

The message says to increase the file locks, in the registry I believe.

Is this a common problem with a simple fix?

 

[CyberLynx]

Microsoft Explain the problem and solution Here.

Hope it solves your problem.

.

 

[williamlove]

Thanks for directing me to this article!