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!

I should add, we are on 2002. Thanks!

"Vicky" wrote:

> 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


--
Joan Wild
Microsoft Access MVP
"Vicky" <(E-Mail Removed)> wrote in message news:58F70506-81B0-45B0-A444-(E-Mail Removed)...
>I should add, we are on 2002. Thanks!
>
> "Vicky" wrote:
>
>> 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!

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?



"Joan Wild" wrote:

> 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
>
>
> --
> Joan Wild
> Microsoft Access MVP
> "Vicky" <(E-Mail Removed)> wrote in message news:58F70506-81B0-45B0-A444-(E-Mail Removed)...
> >I should add, we are on 2002. Thanks!
> >
> > "Vicky" wrote:
> >
> >> 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!
>

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

"Joan Wild" wrote:

> 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
>
>
> --
> Joan Wild
> Microsoft Access MVP
> "Vicky" <(E-Mail Removed)> wrote in message news:58F70506-81B0-45B0-A444-(E-Mail Removed)...
> >I should add, we are on 2002. Thanks!
> >
> > "Vicky" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
news00EFE7D-B513-40DE-9B48-(E-Mail Removed)...
> 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

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" wrote:

> "Vicky" <(E-Mail Removed)> wrote in message
> news00EFE7D-B513-40DE-9B48-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:A1216243-43C8-4A4E-825F-(E-Mail Removed)...
> 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...t%2Fsecfaq.asp