I work at a not for profit daycare. Our database is coming along nicely. One problem, though.
The goal is to host the back-end in a shared folder on the computer at our front desk, and distribute the front-end to the rest of the computers in the office. The issue is that the front-end I've developed opens to a full-screen login prompt. The whole user's experience of the front-end takes place in full-screen. If I encrypt the back-end and then try to open the front-end, I get the login interface which I designed, but I can't log in because Access's password prompt is (I assume) behind my password prompt.
How can I have a decently secure back-end with this UI design? Should I just leave it un-encrypted and make sure that only certain computers can access it? My coworkers have mostly no knowledge of databases. Thanks
EDIT: What about using password sharing on the shared folder? Would this suffice?