Acc97 Permission Question

[Wolfgang Kais]

Dear Newsgroup.

A few days ago, I encountered a problem using a custom property in an
Access 97 database. I created the property using the database properties
window from the file menu. I wrote code like this to read and write the
property in a module:

Function GetMyProperty() As Date
With CurrentDb
With .Containers("Databases")
With .Documents("UserDefined")
GetMyProperty = .Properties("MyProperty")
End With
End With
End With
End Function

Sub LetMyProperty(NewDate As Date)
With CurrentDb
With .Containers("Databases")
With .Documents("UserDefined")
.Properties("MyProperty")= NewDate
End With
End With
End With
End Sub

Accessing the property using these procedures is no problem, as long as
I am logged on to the workspace as the owner of the database.
When a simple user is logged on, he can read the property but when he
tries to change the value he receives an error message stating that he does
not have sufficient permissions on the UserDefined object.
So I granted him permissions using the dbSecFullAccess constant, but he
still gets the same error.
What permissions have to be granted to a user that needs to read and
write a custom property of the UserDefined document?

 

[Tom Wickerath]

Hi Wolfgang,

I do not know, since I don't use ULS. However, I'd like to suggest that you
consider reposting your question in the Microsoft.public.access.security
newsgroup. Here is a link to that group using the Web interface:

http://www.microsoft.com/office/com...spx?dg=microsoft.public.access.security&exp=1

Make sure you mention that you've already posted in MPA, so that you don't
get accused of multi-posting. Also, have you tried Google Advanced Groups
search? I would imagine that this question has come up several times in the
past. For example, the third hit in this search looks promising (I haven't
looked at it yet):

http://groups.google.com/groups?as_...05&as_maxd=28&as_maxm=1&as_maxy=2007&safe=off


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Generally speaking, you need 'admin' rights on the 'database'
object to change database properties. Setting database
properties seems to be considered a kind of 'admin' function.
This includes all the standard database properties (special
keys, menu, start form etc) as well us the user defined
properties.

Note, this right seems to share only it's name with all the other
'admin' rights you can have, like the admin right on a table
or query. The admin right on a table gives you the right
to change user rights to a table. The admin right to a database
does NOT give you the right to change user rights to the
database. That right is reserved for 'a member of the admins
group that created the database'

(david)

 

[Wolfgang Kais]

Thank you david, but:

The property isn't a database property but a property of a document
(that is displayed in the database properties window).
Is al this still true for such properties?