We have been using a Front end/back end database for 3 years now. Recently I have developed a front end with read-only queries to be used on the shop floor. Our IT manager has changed permissions to further protect the data. Initially a few read write users were locked out but after a few permission changes late Friday, things seemed ok.
First thing Monday the production planning queries (these need read write permissions)were reported to have stopped running. They were responding as if the data had been made read only. I then tried to open the back end directly (data.mdb) but it reported a read only database.
The IT Man insists he has not changed things. File permissions look ok when he shows me them. He tried removing all permissions and then adding me with full control but even then it says that data.mdb is read-only when I tried to open it. I can copy the data.mdb to data2.mdb and re-link the front end to data2.mdb and it works. I have 20 user with this front end.
I was considering just deleting and renaming the copied Data2.mdb to data.mdb (to allow users to carry on using there front ends without the need to update to the latest Version) but the original data.mdb cannot be deleted as it says there is a sharing violation, there is no lock file evident so I assume something has corrupted. What could cause this? Is it possible that changing permissions was carried out on the data.mdb while it was open and this caused the problem?
First thing Monday the production planning queries (these need read write permissions)were reported to have stopped running. They were responding as if the data had been made read only. I then tried to open the back end directly (data.mdb) but it reported a read only database.
The IT Man insists he has not changed things. File permissions look ok when he shows me them. He tried removing all permissions and then adding me with full control but even then it says that data.mdb is read-only when I tried to open it. I can copy the data.mdb to data2.mdb and re-link the front end to data2.mdb and it works. I have 20 user with this front end.
I was considering just deleting and renaming the copied Data2.mdb to data.mdb (to allow users to carry on using there front ends without the need to update to the latest Version) but the original data.mdb cannot be deleted as it says there is a sharing violation, there is no lock file evident so I assume something has corrupted. What could cause this? Is it possible that changing permissions was carried out on the data.mdb while it was open and this caused the problem?
