Setting Privileges

[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!

 

[Vicky]

I should add, we are on 2002. Thanks!

 

[Joan Wild]

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

 

[Vicky]

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]

Also, how long do you think it will take me (a novice) ?

 

[Keith Wilby]

Is it not recommended to split it first? Then apply security?

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?

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?

.... 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

 

[Vicky]

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

 

[Keith Wilby]

Keith,
THank you. Checked your website and the FAQ link takes me to a dead site.

Really? I must check that.

Perhaps there is another new link somewhere that you could point me to?

Try this:

http://support.microsoft.com/kb/207793

and this:

http://support.microsoft.com/default.aspx?scid=/support/Access/Content/secfaq.asp