MS Access expert, database administrator
Budget: $30 – $250 USD
I have a MS Access file for more than 100 users. Front end kept in the folder1 and Back end kept in folder2.
ISSUE IS TO PROTECT COPYING THE FILE FROM FOLDER2 i.e. back end file.
Front end file is created following user credentials - user name and password. Only the user can see their own data only using user name and pass.
If I protect folder2 user cannot copy back end file from the folder but -
If I protect folder2 from the properties (see attachment - 'allow' or 'deny') option - users do not have access their data. User credentials are not working. User cannot retrieve their data in front end.
Do you have any solution?
If you can solve it you will be awarded.
ISSUE IS TO PROTECT COPYING THE FILE FROM FOLDER2 i.e. back end file.
Front end file is created following user credentials - user name and password. Only the user can see their own data only using user name and pass.
If I protect folder2 user cannot copy back end file from the folder but -
If I protect folder2 from the properties (see attachment - 'allow' or 'deny') option - users do not have access their data. User credentials are not working. User cannot retrieve their data in front end.
Do you have any solution?
If you can solve it you will be awarded.