Users unable to open database

[mcbass1]

I have two databases that have been split, and both back ends are in a shared folder on the server that only a few people have authorization to access. One of the front ends is accessed off another shared folder, and the other is saved to each person's desktop. They have been up and running for months, and I've had no problems with users not being able to access data from the back end.

The other day, I requested access to this protected folder for four people, which was granted. But, since the time it was granted, neither database will open unless the user has authorization to access the protected folder. They get an error that says the database is already opened exclusively or they don't have authorization to view its data.

I've created another test db and split it into the same folder, but my users are getting the same error.

Any help you can provide would be much appreciated.

Thank you,
Mike

 

[mcbass1]

I'm now being told that if the back end is in a folder that the user doesn't have authorization to access, they won't be able to access the data from the front end. I can understand that, however for months, the back end has been in this protected folder, and users without access to that folder have still been able to access the data from the front end - even though they do not have authorization to access the folder.

Any ideas?
Mike

 

[mcbass1]

OK, I just moved the back end of one of the databases into a shared folder that everyone has authorization to access and re-linked all the tables. My users are still unable to access it, getting the same message that someone either has it open exclusively or they don't have authorization to view the data. I am still able to open it fine though. Strange!