Securing a split Access database

[Mark S]

Hello: I have a split database and the database is Microsoft Access 2003. I
need guidance to create the workgroup security system.mdw file.

Do I need to configure the back-end or front-end database file? The back-end
file resides on a network share and the front-end file resides on a local
workstation.

Thank you, Mark

 

[Joan Wild]

One generally does both. You'll want to make sure that both the FE and BE is secured using the same workgroup file.

Security is difficult to master. Study up on it, and then practice on a copy of your database. Some resources:
Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

You might find it easier to secure a single mdb (i.e. unsplit it first); and then split it after it is secured. Don't use the splitter wizard though, as that will remove all the security on the BE. See www.jmwild.com/SplitSecure.htm


--
Joan Wild
Microsoft Access MVP
: Hello: I have a split database and the database is Microsoft Access 2003. I
: need guidance to create the workgroup security system.mdw file.
:
: Do I need to configure the back-end or front-end database file? The back-end
: file resides on a network share and the front-end file resides on a local
: workstation.
:
: Thank you, Mark

 

[Mark S]

Thank you again, Joan!