File Sharing Lock exceeded - when saving vb code

[ACTHelp]

I've seen the file sharing lock exceeded error on this board many times for when the Access application is running, but I am experiencing this problem when trying to save a vb module...

What would cause this problem?

 

[markphsd]

Is it the table lock, or a file lock on the Access File?

This is one guess:
Do you have two instances of the application open? Maybe it canceled out and you started up another, but the first is still running in the background. Check Windows Task Manager under the processes tab to see if you have two instances of MSAccess.exe


Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[ACTHelp]

Unfortunately, that doesn't seem to be it either, I've checked the running processes and msaccess is not there nor do I see any references to anything that looks like vb.

Still stumped..

By the way, we are running Windows 2000, Access 2000 (9.06926 sp3) and VB 6.3

 

[ACTHelp]

I managed to resolve this myself. Part of this application opened Excel spreadsheets and PPX files from PowerPlay. These resources were not being released. When the release of these resources was added, the problem was resolved.