I've run a comprehensive staff db on the network for 2 years using MS Access 97 backend and VB6 front end. Every now and then I update the code and recompile the executable. Always been working fine. I did some amendments yesterday, only changing some filepaths on the connection strings.
When I try it from within VB6 (F5) it work fine. However, when I compile the executable and trye the exe file from the SAME PC I get the following error:
Run-time error '-2147217843(80040e4d)':
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Yes, I have checked and tried that the file is not opened exclusively by another user. In Access, the default open mode is set to "Shared".
Any help would be much appreciated.