How to Deny administrative priviliges to the default admin user of

[Guest]

Hi
I have developed a database in MS Access (XP version) by creating a new
workgroup file. Since we cant remove default admin group of the Access
therefore i created another member of this Admin Group with full privileges.
Moreover i took away all permissions from the default admin user of the
default Admin group. Now since my database is available on a LAN, any user
from any work station of this LAN when tries to open this databe which has
been placed on my work station , cannot open it if he using MS Office XP
version. This happens even when he has not joined the workgroup information
file which i have created for users of my database. When the user of this LAN
joins the workgroup file of this datbase then they are asked their login name
and password etc.
Uptill here it is fine. However the problem is that whenever a new user
accesses my databse from any of the work station of ths LAN for the first
time and he is using MS Office 2000 version or any version beyond MS Office
XP, can open my database without any problem. Although i have disable the
default admin user of Access but any user who has previuos version of MS
Office than XP version and has not joined the specified workgroup file can
open my database.
I want to prevent all users who are not registered in my workgroup
information file and are using default work group information file of the MS
Access from having access to my datbase. How is this possible?
I hope i have made u understand the problem.... Please help me resolve this

 

[Douglas J. Steele]

It would appear that you didn't apply security properly. You say you "took
away all permissions from the default admin user of the default Admin
group". How exactly did you do that? You should have removed the default
admin user from the default Admin group.

Check the Access Security FAQ at
http://support.microsoft.com/support/access/content/secfaq.asp

 

[Scott McDaniel]

If you didn't remove the Admin user from the Admins group, then you didn't
remove the permissions. The Admin user has no explicit permissions; it
derives all permissions via the association with the Admins group. Thus ANY
user you put into the Admins group automatically is granted ALL permissions.
All users are also members of the Users group, thus any permission you grant
to the Users group is granted to ALL users, regardless of any other
grant/deny setting.