J
Jad.
Hi all!
I'm trying to automate the securisation of .mdb files
which will be created later. I think I have understood the
Access security model, but when it comes to code all of
this using DAO, it seems much more blurred...
I created a sample security model using the wizard, and I
try to explore permissions using DAO.
I'm using a modified code from microsoft's website :
For i = 0 To dbs.Containers.Count - 1
For j = 0 To dbs.Containers(i).Documents.Count - 1
dbs.Containers(i).Documents(j).UserName = "coAdmins"
dbs.Containers(i).Documents(j).Permissions _
= dbSecFullAccess
Next intCtrCount
Next intDocCount
This is a very simple code that simply roam through all
your objects, changing the permissions for the
group "coAdmins". Well at least it's why I imagine. Now
the problem is access will just tell my I can't access the
records, because I don't have read permission for
AccessLayout.
I am logged under a user which is part of the Admins
group, and if I list permissions for this user, I see that
everything it at 0, except for MSysDb, which has the
dbSecFullAccess value.
What does exactly represent this MSysDb thing?
Why can't I change permissions for other users/groups?
Oh and this happens on a remote database, which has been
secured using the wizard, but this happens also if I open
this database and execute the code directly in it.
Thank you and sory for this long message
I'm trying to automate the securisation of .mdb files
which will be created later. I think I have understood the
Access security model, but when it comes to code all of
this using DAO, it seems much more blurred...
I created a sample security model using the wizard, and I
try to explore permissions using DAO.
I'm using a modified code from microsoft's website :
For i = 0 To dbs.Containers.Count - 1
For j = 0 To dbs.Containers(i).Documents.Count - 1
dbs.Containers(i).Documents(j).UserName = "coAdmins"
dbs.Containers(i).Documents(j).Permissions _
= dbSecFullAccess
Next intCtrCount
Next intDocCount
This is a very simple code that simply roam through all
your objects, changing the permissions for the
group "coAdmins". Well at least it's why I imagine. Now
the problem is access will just tell my I can't access the
records, because I don't have read permission for
AccessLayout.
I am logged under a user which is part of the Admins
group, and if I list permissions for this user, I see that
everything it at 0, except for MSysDb, which has the
dbSecFullAccess value.
What does exactly represent this MSysDb thing?
Why can't I change permissions for other users/groups?
Oh and this happens on a remote database, which has been
secured using the wizard, but this happens also if I open
this database and execute the code directly in it.
Thank you and sory for this long message