Split database security

[ubu]

What's the best approach for setting up security on a
split database? Is it better to set it up on the front
end and then copy it to all the local computers?

Will users still be able to connect to the backend?

The database I'm working with is already split and I need
to set up security.

 

[Scott McDaniel]

You setup security on BOTH the front and back end, and you do so using the
same workgroup. Yes, setup security before deploying your frontend. If you
haven't already done so, downloand read-read-read the MS Access Security
FAQ:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

After deploying, users should start the application via a shortcut with the
Target setting something like this:

"Path to MSAccess.exe" "Path to your db" /wrkgrp "Path to your .mdw file"