Hello!
On our network we have a team of 5 or 6 people on our domain who share an Access 2007 accdb database on a network drive. It's split and everybody has their own local FE as advised. We've never had a problem with multiple team members being in the file together.
Last week, I upgraded one of our users from an XP system to Win7. Now that user is unable to open the shared database. She is receiving the error "Cannot Lock File" whenever she opens it through her shortcut. I've run a few searches here and invested a possibly unhealthy amount of time surfing google for answers, and here's what I've tried:
Verified that the user is a local administrator.
Verified that the user has appropriate rights for the directory and files.
*Same rights as other users who have no problems.
Verified that the ODBC sources are set up the same as the other Win7 machines that work fine.
I've also tried using the registry edit method to alter the MaxLocksPerFile field as suggested by Microsoft at http://support.microsoft.com/kb/305995 .
This user had no problems at all when she was still using Windows XP, so I think it could be local issue with the machine or Access configuration. I just don't know what else I could check.
It would be awesome if someone had some ideas of things I might be missing or forgetting to look at. Thanks!