Access security question on a split db

[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

 

[Keith Wilby]

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

 

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