Securing front and back end using same mdw

[Ripper]

I am using Access 07, but keeping the file in 2003 format. I ran the
security wizard on my backend and created an mdw that is stored in the same
location as my backend. Now I want to secure the front end. Do I need to
secure it with the same mdw as my backend? If so, how do I do that?

Please help. Learning Access Security for the first time.

 

[Joan Wild]

Yes, you want to secure the frontend using the same MDW. Backup what
you've got now (backend, frontend, secure mdw) in case the following
doesn't work:

I believe that when you run the wizard, one of the steps asks you
whether to use the current mdw, or create a new one. So start a session
of Access using your secure mdw, and run the wizard on the frontend. To
start a session using that mdw create a desktop shortcut with the
following in the target:
"path to 2007 msaccess.exe" /wrkgrp "path to secure mdw"

When you get to that step, tell it to use the current mdw.

Joan Wild

 

[Ripper]

That seems to work well, but I have to go through and add all the permissions
for the new forms etc. Would it be easier to create a single database,
secure it, and then split it on my own?

 

[Joan Wild]

It might be (about the same really). But if you go this route, don't
use the splitter wizard to split the database, as that will result in an
unsecure backend. It's quite easy to split manually though - see
www.jmwild.com/SplitSecure.htm


Joan Wild

 

[Ripper]

Thanks Joan. Security is a bear to get my head around.