Network Security Admin Problem

[Kimberly Weinberg]

I have Followed Access Security FAQ step 1 exactly inorder
to protect my networked database with multiple users. I am
trying to keep other users from logging on as exclusive
because no mdw file has been established. Am I totally
stupid? Help

I am unable to change the mdw files after they are
created so that my user name and password are the only
Admins.

I can't get beyond creating the new user, putting it in
Admins and Users Group and removing old Admins from the
Admins group. When I close access and attempt to open the
database it will ask for tho initial user name and but the
new password.

I have created many mdw files, deleted them, and have
little luck changing them in design view.

 

[Scott McDaniel]

Somewhere along the line you're missing a step. Following the Security FAQ
can be tricky, but Lynn Trapp has a simplified version of how to secure a
database on her site:

http://www.ltcomputerdesigns.com/The10Steps.htm

She's also got a couple of links to other sites that may help you. I
encourage you to try this on a COPY of your database ...

 

[Joan Wild]

Somewhere along the line you're missing a step. Following the Security FAQ
can be tricky, but Lynn Trapp has a simplified version of how to secure a
database on her site:

That would be....'his site'.

 

[kimberly]

I have attempted the summarized version and at her step 6
I am unable to remove the admin user, there is no way to
highlight the selected changes. Any ideas?

 

[Scott McDaniel]

Whoops ... sorry ... thanks for the correction,

 

[Scott McDaniel]

You cannot remove the Admin user, just as you cannot delete the Users group
.... instead, make sure that the Admin user has no explicit permission and
isn't a member of any group. Of course, you can't remove the Admin user from
the Users group (all users are irrevocably members of the Users group), but
you can remove all permissions from the Users group. Also, make sure to
change ownership of the database ... there is a document on Lynn Trapp's
site regarding the DB Owner and how to change it.

 

[Lynn Trapp]

That would be....'his site'.

<huge grin>



--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp

 

[Lynn Trapp]

Not a problem, Scott. You are not the first to make that mistake and
probably won't be the last either. In fact, most of the MVPs thought I was a
woman at first.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Security FAQ: http://support.microsoft.com/support/access/content/secfaq.asp