Access 97 Permission Question

W

Wolfgang Kais

Dear Newsgroup.

I have already posted this question in the microsoft.public.access group
and MVP Tom Wickerath suggested to repost it here:

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top