I've tried searching but not managed to find anything that quite solves our problem.
Our situation is a legacy VB6 application using Access as a back end in a multi user environment.
The database is on an external drive connected to a computer running Windows10..
Other users are mostly still using Windows7. This has been the case for a couple of years. So, nothing new in terms of the environment.
Recently we got the "Locked Exclusively by another user" message on all machines. I initially thought that an instance of the application had crashed while editing or with a DBGrid open. That turned out not to be the case. Rebooting everything didn't help.
The icon that usually appears next to the Access file in Windows Explorer when a grid is open or the file is open in Access is not present.
I wondered if an update had somehow changed permissions somewhere but could not find anything. I opened the Database file in Access to see that Editing is still allowed.
So, I lastly decided that maybe the file was corrupt. So, I replaced the current file with previous day's backup and that solved the problem for the machine attached to the external drive where the database is located.But....same message on all other computers. I've experimented with using quite old backups that were well before this problem developed in case we had suffered some sort of corruption that only affects a networked user. No dice.
Otherwise, the network functions as usual in terms of file sharing etc...
So, not being a developer or an IT guy I'm stumped.
Any Ideas?
Thanks,
Jon