Security Wizard and Split Databases

RDSJMS

Registered User.
Local time
Today, 03:04
Joined
Jan 25, 2006
Messages
30
Should the Security Wizard be run to create the user rights before or after splitting the database? If it's run before splitting, does that mean that the .mdw will control both the front end and back end, versus running it after splitting it will only control the front end? I'm planning on having the back end on a server with no user rights to traverse the directory.

When should I convert the front end to an .mde - before or after running the Security Wizard, before or after splitting?

Any and all replies would be greatly appreciated by this Access rookie.
 
Well, I can tell you that running it before you split means you may have issues moving security over when you split. In other words, say you create your security on a master copy, which you will use to split into the be and fe.

Server
Master Folder (security created here - used to create the below)
Back-End Folder
Front-End Folder(s)

I can never get the security to "carry over" into the be and fe. There also seems to be an issue with the shortcuts. The mdw shortcut that is developed works great, if it stays in the original folder. Move that puppy anywhere else and it stops working. No more logon screen, nothing.

So, as it stands right now, I have given up on the security wizard, because getting the backend and frontend set up is more important. My database does not containt sensitive data.
 

Users who are viewing this thread

Back
Top Bottom