Hello All,
Apologies if this has been dealt with in other posts but I could not find any information on this.
Our company has been using a database for a number of years, but I am in the process of updating the security of all the databases.
I have split the database, put the Back end (password protected) into a hidden share on our Server. I have then granted read/write access to those who need it.
Everything works fine using this. When i give the front end to all the relevant users, all works well. Note: when the database is opened, it is set up to open the "Home" Form.
However, if this user gives a copy of the front end to another user who doesn't have access. The first message that appears when they open it is:
The Microsoft Access database engine cannot open or write to the file '\\ FILE LOCATION. :banghead:
I am looking for a way to stop this error message appearing, as it gives the location of the back end.
I appreciate your help with the above, and apologize if it has been answered elsewhere.
Apologies if this has been dealt with in other posts but I could not find any information on this.
Our company has been using a database for a number of years, but I am in the process of updating the security of all the databases.
I have split the database, put the Back end (password protected) into a hidden share on our Server. I have then granted read/write access to those who need it.
Everything works fine using this. When i give the front end to all the relevant users, all works well. Note: when the database is opened, it is set up to open the "Home" Form.
However, if this user gives a copy of the front end to another user who doesn't have access. The first message that appears when they open it is:
The Microsoft Access database engine cannot open or write to the file '\\ FILE LOCATION. :banghead:
I am looking for a way to stop this error message appearing, as it gives the location of the back end.
I appreciate your help with the above, and apologize if it has been answered elsewhere.