G
Guest
I have tried to set the ms-access security and created a new user account via
Extras - Security - user and group accounts (I try to translate it from the
German language version, so I 'm not sure whether it is exactly what apperas
in the English version, sorry!). Then I activated the login password by
setting it with the administrator account and - after a new start of access -
with one of the newly created user accounts. Everything works just fine! I
had to select the user and to supply the password in order to open the
database.
But when I login to my computer using a different Windows account and open
the Access database, the security settings are gone. Everybody can do
everything with the database. Logon to Windows (Win2000Pro) using the account
under which I created the access security restores the database security, I
have to provide the account name and passwrod when trying to open the
database.
I though it might be that the system.mdw file is created in the profile of a
specific Windows user. So, I deleted that file and created a new one with the
access procedure but placed that system.mdw file now in that directory which
has the database itself and which is accesible to all users. No better, same
behaviour as described above.
So what does access ecurity mean if everybody else has full access to the
database ecxept me?
Any suggestions out there? Thanks
Alfons
Extras - Security - user and group accounts (I try to translate it from the
German language version, so I 'm not sure whether it is exactly what apperas
in the English version, sorry!). Then I activated the login password by
setting it with the administrator account and - after a new start of access -
with one of the newly created user accounts. Everything works just fine! I
had to select the user and to supply the password in order to open the
database.
But when I login to my computer using a different Windows account and open
the Access database, the security settings are gone. Everybody can do
everything with the database. Logon to Windows (Win2000Pro) using the account
under which I created the access security restores the database security, I
have to provide the account name and passwrod when trying to open the
database.
I though it might be that the system.mdw file is created in the profile of a
specific Windows user. So, I deleted that file and created a new one with the
access procedure but placed that system.mdw file now in that directory which
has the database itself and which is accesible to all users. No better, same
behaviour as described above.
So what does access ecurity mean if everybody else has full access to the
database ecxept me?
Any suggestions out there? Thanks
Alfons