Hi, I am setting up an Access 2010 (Ver. 14) split database. The db is very simple 2 table file (one for data, one for attachments).


I plan to put this on a network share for about 4 users, all of whom will share a single login/pass.

I just encrypted the front end and got a warning message that "Encrypting with a block cipher is incompatible with row level locking. Row level locking will be ignored"
I haven't encrypted the backend yet.

I searched a bit to figure out if this is going to lead to corruption, and this article mentions that I should not encrypt the backend.
What do you suggest? Encrypt the backend and the frontend?

How is this going to affect simultaneous multiuser work?