[AccessD] Error message - Record(s) can't be read; no read permission on 'MSysGroups'.

What version of Access are you using?  As I recall, you're going to have
to open the workspace using a login with full security permissions in
order to test the groups unless the group the currentuser is in already
has those permissions.

Charlotte Foust

-----Original Message-----
From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk] 
Sent: Friday, April 11, 2003 2:00 AM
To: 'AccessD at databaseadvisors.com'
Subject: [AccessD] Error message - Record(s) can't be read; no read
permission on 'MSysGroups'.


Hi

getting this error - user has read, write, insert and delete access for
all tables in front end and BE

I get when in this function

Private Function IsInAdmin(Optional strUser As String = "") As Integer
Dim grp As Group
  If strUser = "" Then strUser = CurrentUser
  For Each grp In DBEngine.Workspaces(0).Users(strUser).Groups
<<<<<<<<<<<<<<<<  error here
    If grp.Name = "Admins" Then
      IsInAdmin = True
      Exit For
    End If
  Next
End Function


Can u help please

Richard
------------------------------------------------------------------------
--------------------------------------------
This e-mail, together with any files transmitted with it, is
confidential and intended solely for the use of the individual to whom
it is addressed. If you are not the intended recipient, or the person
responsible for delivering to the intended recipient, be advised that
you have received this e-mail in error and that any use, dissemination,
forwarding, printing or copying of this e-mail is strictly prohibited
without liability on our part.

By responding to this e-mail it is accepted that your response 
may be the subject of recording/monitoring to ensure compliance 
with the Council's ICT Security Policy

If you have received this e-mail in error please notify the sender.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com