With the help of this forum's users, I created a small trial db (one table with about 350 records and another of less than 10) for viewing scanned images. The db links to images stored outside the db by use of two text fields per record each with the path to an image.
I added one text box on a previously fabulously working form (thanks Rural Guy) to show one ancillary text field of data and after setting up the text box, I received the following error when I went to run the form.
File sharing lock count exceeded. Increase MaxLocksPerFile registry entry.
Microsoft support article ID 815281 gave two options as workarounds. One involved altering my computer's registry (I'm a bit nervous about that; I am amateaurish with computers beyond application software.) and the other involves the temporary use of the Immediate Window in the VB editor.
There is lots of traffic on the web about this problem. After reviewing some of this traffic, most of which is over my programming head, my lack of sophistication leaves me with three initial questions:A bit of information which may shed some light, my db switchbox is VERY slow to open when I start my db as are my key forms when first opened. If I close a form, then reopen the same form, the second time and thereafter the form opens quickly.
- Can anyone provide insight into the two possible workarounds from 815281 or other options that may be available and their relative utility and potential pitfalls?
- What causes a file sharing lock?
- In the hopes of streamlining my relatively small db which could grow rapidly, how can I get around this problem with db design?