Securing a split database

[Guest]

Hello.

I've looked through a few of the threads to avoid repeating an issue that
may have already been covered, but did not see any.

I have a split FE/BE database that I would like to secure. My first
question is how do I secure both? I've only seen resoultions that address
how to split it AFTER the dbase has been secured.

My second question is a bit more complex.

The dbase is designed for a multiuser environment. The FE is on the user's
individual workstation. The BE resides on the network. I am constantly
making changes to the FE and so in order to make sure that each user is
working with the latest and greatest version of the FE, I use a program
(thanks to Tony Towes) that copies the "master" copy of the FE database and
puts it on the user's workstation. If I use the Security Wizard to secure my
database, I select the option that puts a shortcut to the "secure.mdw"
database on the desktop since one can not open the "secure.mdw" on its own.
How can I keep the latest and greatest FE on the user's workstation and still
keep it secure? Hope this makes sence.

Any help would be appreciated.

Thanks in advance,

m.

 

[Chris Mills]

I have a split FE/BE database that I would like to secure. My first

question is how do I secure both? I've only seen resoultions that address
how to split it AFTER the dbase has been secured.

You secure them both in the same way. They are two entirely separate mdb's.
For each, you secure them in an identical fashion using the same Workgroup
file, etc. FE and BE are merely how you use them, they don't know whether
they're FE's or BE's. It's just easier (less work) to secure one mdb and then
split it.

The FE will have links of course. Arguably, it doesn't matter what security is
placed on the links, which is just security on the links themselves. Security
is determined by permissions on the actual table (in the BE).

The dbase is designed for a multiuser environment. The FE is on the user's
individual workstation. The BE resides on the network. I am constantly
making changes to the FE and so in order to make sure that each user is
working with the latest and greatest version of the FE, I use a program
(thanks to Tony Towes) that copies the "master" copy of the FE database and
puts it on the user's workstation. If I use the Security Wizard to secure my
database, I select the option that puts a shortcut to the "secure.mdw"
database on the desktop since one can not open the "secure.mdw" on its own.
How can I keep the latest and greatest FE on the user's workstation and still
keep it secure? Hope this makes sence.

I wasn't aware Tony's method had anything to do with security. Shortcuts are
setup in the initial installation. Just replacing the FE with a new version
has nothing to do with creating or maintaining shortcuts.

BTW I believe Toews is pronounced with a v (since I read aloud <guffaw>)
Chris