Setting Privileges

  • Thread starter Thread starter Vicky
  • Start date Start date
V

Vicky

I have a database that I share with 6-7 others. I read somewhere that if I
want to apply security to the database, I have to split it into Front End and
Back End db's and then apply the privileges. Is it possible to set
privileges without splitting. Is splitting a good idea for a small group
like this. The list of users could potentially get larger.

I am thinking that the 2 features, splitting and privileges are mutually
exclusive and I can do one without the other. Right?

The book I read made it seem I had to do both.

Much Thanks!
 
You can do one without the other, yes. However it is strongly recommended that you split the database, especially for multiusers.

I'd recommend that you secure it as a single mdb, and then split it - don't use the splitter wizard on a secure mdb, as that will result in an unsecure backend. Split it manually; see www.jmwild.com/SplitSecure.htm
 
Is it not recommended to split it first? Then apply security? How difficult
is this? What are the potential problems I might face? Someone asked me to
do this for them. I guess I just need a backup copy before I begin, right?
 
Vicky said:
Is it not recommended to split it first? Then apply security?
Click to expand...

It doesn't matter, it's no big deal to split a secured app.
How difficult
is this? What are the potential problems I might face?
Click to expand...

If you're new to security then it's not easy. You can easily lock yourself
out, so ...
Someone asked me to
do this for them. I guess I just need a backup copy before I begin,
right?
Click to expand...

.... make regular backups. If you're going to apply security then make sure
you read the FAQ (link on my web site). There's no filler in that document
so make sure that you follow all of the steps in the order stated.

Keith.
www.keithwilby.com
 
Keith,
THank you. Checked your website and the FAQ link takes me to a dead site.
Perhaps there is another new link somewhere that you could point me to?

Thank you!
VIcky
 
Back
Top