Password on the backend and is it recommended?

[BittenApple]

Hello team,
I wonder if we can put password on the backend of the table and is act recommended?
Regards,
BittenApple

[HansV]

What do you want to accomplish with protecting the backend with a password?

[BittenApple]

Hello Hans,
I want to protect back end of the database.
Regards,
BittenApple

[HansV]

It would probably be better to place the backend in a folder on which only the database users have permissions, so that others can't open the folder...

Also: if you forget the password, it'll be difficult to retrieve the data from the database, since it will have been encrypted.

[BittenApple]

Hello Hans,
Do you mean of database users, end users?
I have a folder that has the backend, then under that there is 50 subfolders, one for each user and the front end copy is put in the subfolders. End users can put their copy on their own location (as long as they are going to stay in same drive).

I am afraid end user go and do some changes on the backend?
I am not going to forget my pw?

Regards,
BittenApple

[HansV]

People who use your database need to have full permissions (read, write, create, delete) on the folder that contains their frontend database AND also on the folder that contains the backend database. Otherwise, Access won't work correctly. So anyone who uses your database can, in theory, delete the backend...
(So make sure that the backend is updated frequently!)

But you can indeed protect the backend with a password. You will have to relink the tables in each frontend.

[BittenApple]

Hans,
Are you saying that after I put the password, I have to relink the tables to each frontend?
Regards,
BittenApple

[HansV]

Yes, that is correct.

[BittenApple]

Thanks!