First of all, I have to say that I don’t know if this is a network issue or a Microsoft Access issue. I’m by no means an expert in either area, I’m just trying to help two of my employees who are spinning their wheels with a problem we’re having.
We have an Access database that is being used by a remote location. This database is set to ‘Share’ and set to not have record locks. The file permissions on the folder are set as appropriate. The problem is, when one person is in the database, then anyone else who tries to access it can ‘read only’. Also, when my employees try to open the database via the shortcut they created, it won’t open, but if they browse network neighborhood, they can get to it.
I realize this isn’t a lot of information, but it’s about all I have to go on right now. I’d be glad to provide more if you have any specific questions.
