File sharing lock count exceeded.

[oleBucky]

I recreated the text box and the file sharing lock count error reoccurred. Bummer! Any suggestions?

[RuralGuy]

Any chance you can Compact and Repair the db and then zip it up and attach to a post?

[oleBucky]

That would be great. However, the zip file is 14.7 MB (the unzipped db is now down to 56.8 MB from 195 MB earlier); significantly larger than the 2MB zip file size limit. Anyway around that?

[RuralGuy]

With which form are you having trouble?

[RuralGuy]

BTW, internally stored pictures *will* bloat a db and displaying them regardless of where thay are located will slow things down.

[oleBucky]

frmImages. It's the form associated with the "Open Game Display" button on the switchboard.

[oleBucky]

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.

I went ahead and bit the bullet and updated my registry. I increased the MaxLocksPerFile entry from 9,500 to 950,000. This allowed me to enter the ONE text box that was giving me fits.

I am still confused as to what causes a share lock and thereby drives up the count. I welcome any direction or input.

[RuralGuy]

I wish I had more information for you but alas, I do not!