Securing BackEnd DB file

[Jeff]

I split my database into frontend and backend and have also secured the
frontend. I want to secure the backend also with the same security file.

How do I do that?

I tried performing the user level security wizard again on the backend file
but my only choice in the wizard is to create a new security file. Any ideas?

The only thing I can think of is to export everything back into a new
unsecured access file and try again.

 

[Joan Wild]

I split my database into frontend and backend and have also secured
the frontend. I want to secure the backend also with the same
security file.

How do I do that?

I tried performing the user level security wizard again on the
backend file but my only choice in the wizard is to create a new
security file. Any ideas?

I'll assume you are using 2002 or 2003. The wizard gives you only that
choice because you are currently joined by default to system.mdw (and this
workgroup should not be altered).

Open Access and use Tools, Security Workgroup Administrator to join the
secure mdw you used to secure the frontend. Next open the backend and run
the wizard. You should be given the option to use the current workgroup
file.

Once you are done, you can rejoin the standard system.mdw workgroup.

 

[Jeff]

I am using 2003 application but have created a 2000 compatible database
because some of the users only have that version.

I did what you said but it doesnt matter. After I go through all that, when
I open the backend file it doesnt prompt me for the username and password.

I'll try repeating your steps with this on a computer running Access 2000
and see what happens.

 

[Jeff]

I am going to start over again with a version that is not secured and not
split yet.

I should enable the user level security before I split into two files (front
and back end) correct?

thx
Jeff

 

[Joan Wild]

I am using 2003 application but have created a 2000 compatible
database because some of the users only have that version.

I did what you said but it doesnt matter. After I go through all
that, when I open the backend file it doesnt prompt me for the
username and password.

OK, instead open Access and use Tools, security, workgroup administrator and
join your secure mdw (the one used to secure the frontend). Then close
Access and reopen it. Create a new mdb (you should be prompted for a login,
so login using a username that's a member of the Admins Group). Import all
the objects from the backend database. Then go to Tools, Security,
Permissions and assign permissions manually:

1. remove all permissions to every object (including the database object)
for the Users Group.
2. assign the permissions you want to your groups

 

[Joan Wild]

I am going to start over again with a version that is not secured and
not split yet.
OK.


I should enable the user level security before I split into two files
(front and back end) correct?

I would. However when you split, don't use the Database splitter, because
that will result in an unsecure backend. Instead split it manually - steps
at
http://www.jmwild.com/SplitSecure.htm

 

[Jeff]

Your instructions on the website worked great! So simple too.

Thx
Jeff