Home All Groups Group Topic Archive Search About

Access security question on a split db

Author
25 Sep 2007 9:16 PM
Manny
Hi,

Joan I think it's you who may have the answer, I have read your steps for
securing a db but what I am confused about is how it works for the split db. 
Will both the fe and the be use the same wrkgrp file?  I have an app that I
am developing and using security.  What I would like clarified is when the
user logs in using a modified short that points to a wrkgrp file on the
network does the be automatically become part of the wrkgrp?  I am having
locking problems and it's driving me and my client crazy! So how would the
steps for securing a database be modified when doing an fe/be multi user app?
And finally, I have the package wizard and would like to know if there are
any considerations for creating an install wizard and how will security be
affected on the installed machine.

Of course if anyone could assist I would appreciate it.

Thanks,

Manny

Author
26 Sep 2007 9:44 AM
Keith Wilby
"Manny" <ma***@discussions.microsoft.com> wrote in message
news:DD69ED30-0617-4956-BEF3-7E9D54C5D3F7@microsoft.com...
> Hi,
>
> Joan I think it's you who may have the answer, I have read your steps for
> securing a db but what I am confused about is how it works for the split
> db.
> Will both the fe and the be use the same wrkgrp file?

Yes.  You will need to secure both files whilst joined to your custom
workgroup.

> I have an app that I
> am developing and using security.  What I would like clarified is when the
> user logs in using a modified short that points to a wrkgrp file on the
> network does the be automatically become part of the wrkgrp?

Not automatically no, you have to secure the file whilst joined to your
custom workgroup.

> I am having
> locking problems and it's driving me and my client crazy! So how would the
> steps for securing a database be modified when doing an fe/be multi user
> app?

I find the easiest way to secure a split database is to secure before
splitting.  You can then copy the secure file and make the two split files
from them already secured.  If already split then join your custom workgroup
and then apply security settings.

> And finally, I have the package wizard and would like to know if there are
> any considerations for creating an install wizard and how will security be
> affected on the installed machine.
>

You've lost me there, do you mean Developer Extensions?

Keith.
www.keithwilby.com
Author
26 Sep 2007 11:40 AM
Manny
Thanks Keith, and yes I meant the Developer Extensions.  In that question I
was wondering about ownership of the db as well, will the installation
reassign ownership?  Should the install be run signed in as Administrator?

Show quote
"Keith Wilby" wrote:

> "Manny" <ma***@discussions.microsoft.com> wrote in message
> news:DD69ED30-0617-4956-BEF3-7E9D54C5D3F7@microsoft.com...
> > Hi,
> >
> > Joan I think it's you who may have the answer, I have read your steps for
> > securing a db but what I am confused about is how it works for the split
> > db.
> > Will both the fe and the be use the same wrkgrp file?
>
> Yes.  You will need to secure both files whilst joined to your custom
> workgroup.
>
> > I have an app that I
> > am developing and using security.  What I would like clarified is when the
> > user logs in using a modified short that points to a wrkgrp file on the
> > network does the be automatically become part of the wrkgrp?
>
> Not automatically no, you have to secure the file whilst joined to your
> custom workgroup.
>
> > I am having
> > locking problems and it's driving me and my client crazy! So how would the
> > steps for securing a database be modified when doing an fe/be multi user
> > app?
>
> I find the easiest way to secure a split database is to secure before
> splitting.  You can then copy the secure file and make the two split files
> from them already secured.  If already split then join your custom workgroup
> and then apply security settings.
>
> > And finally, I have the package wizard and would like to know if there are
> > any considerations for creating an install wizard and how will security be
> > affected on the installed machine.
> >
>
> You've lost me there, do you mean Developer Extensions?
>
> Keith.
> www.keithwilby.com
>
>

AddThis Social Bookmark Button