G
Guest
i have developed a database but i am encountering a problem in its security.
the problem is that i have shared my databse on a LAN. i have allotted each
user a login name and password by making a separate workgroup file. both the
database and work group information file are on my PC on the LAN. Now when a
user who wishes to use my database on his PC joins this workgroup file is
asked to enter his login and password. However, this only happens with those
users who are using ms office xp version. Users who r using older version of
office or for that matter access and have not joined the work group info file
of my database when open my databse they are allowed administrator
permissions automatically. Although i have disallowed administer permissions
for default admin group of ms access but still if someone is using older
version of access i.e 2000 or beyond gets full permission of administrator.
this can jeopardize security of my database over the LAN.
so please help me in this regard.
my email address is
(e-mail address removed)
i shall be obliged
the problem is that i have shared my databse on a LAN. i have allotted each
user a login name and password by making a separate workgroup file. both the
database and work group information file are on my PC on the LAN. Now when a
user who wishes to use my database on his PC joins this workgroup file is
asked to enter his login and password. However, this only happens with those
users who are using ms office xp version. Users who r using older version of
office or for that matter access and have not joined the work group info file
of my database when open my databse they are allowed administrator
permissions automatically. Although i have disallowed administer permissions
for default admin group of ms access but still if someone is using older
version of access i.e 2000 or beyond gets full permission of administrator.
this can jeopardize security of my database over the LAN.
so please help me in this regard.
my email address is
(e-mail address removed)
i shall be obliged