mdw user permissions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases, one is a copy of the other. One database works fine.
The other, at a particular stage of use, gives the error message "The
expression On Dbl Click you entered as the event property setting produced
the following error: Records cannot be edited; no update permission on
'PERSON'."

I have checked that the user I was logged in as belongs to a particular
group, and I have checked that the group has update permissions on the PERSON
table.

Any suggestions on what to look at next?
 
OK - I've worked out how to fix the problem although I don't know what went
wrong or how.

The database is a multi-user database, and although the front-end and
back-end both use the same mdw file, the permissions were different for table
access permissions in the FE relative to the BE.

Access security continues to give me a headache every day. I'm tempted just
to remove all security - I'd rather have the data nicked thatn put up with
this farce. The data doesn't seem particularly secure anyway.

rant over.
 
Hi inbreda,

I'm having the same issue.

How is it possible that the permissions can be different when its all
coming from the same MDW? How did you fix this?

Thanks!
 
It's possible because permissions are not stored in the MDW. They are
stored in the MDB file.
 
But like Paulsoaresjr says, all of the files came from the same MDB file.
They were all copies of the original MDB using the same MDW.

I fixed it by going through the lengthy process of double-checking and
re-assigning permissions to all forms/queries/reports in all copies of the
MDB, whether they are FE or BE.

Doesn't exactly give me confidence in MS Access.

The same sort of thing happened when I split the db into FE and BE (I
followed Joan Wilds useful site for splitting DBs). Permissions got all
mucked up, and subsequently I had to re-jig everything.
 
inbreda said:
But like Paulsoaresjr says, all of the files came from the same MDB
file. They were all copies of the original MDB using the same MDW.
Click to expand...

But then if you set a permission in one copy of the mdb, it's only in that
file, not the rest.
 
Back
Top