No Access to this form

[pdbowling]

Hello, Everyone.

I have inherited an Access DB and must learn to support it.

I have Access 2010 on my machine. The db file lives on the network.

I have a user who cannot get in to some of the forms she needs due to the 'You do not have access to this form.' error.

I looked in the code behind for one of the buttons and it is not handled there.

Private Sub ACCOUNTING_button_Click()
    On Error GoTo Error_Handler
 
    DoCmd.OpenForm "MNU_ACCOUNTING"
 
Exit_Handler:
    Exit Sub
 
Error_Handler:
    If err.NUMBER = 2501 Then
        'Error 2501 = The OpenForm action was canceled.
        'Not really an error. Just indicates we were unable to open the form, which is normal if we have insufficient rights.
    Else
        MsgBox err.DESCRIPTION, vbCritical
    End If
    Resume Exit_Handler
End Sub

I am sad to say that I do not even know where to begin pulling this apart. Is there a tutorial or some advice on where security is handled? I read some confusing articles about there not being stand alone security after Access 2007.


Thanks
Patrick B

 

[Andrzejek]

What I usually do is:
highlight the name of the control: ACCOUNTING_button
Ctrl-C, Ctrl-F, Ctrl-V (copy, find, paste)
and look thru the code what happens to that control.

You may also look for a message box "You do not have access to this form."

'Invest' in MZTools - you will like it

Have fun.

---- Andy

 

[missinglinq]

This is apparently used in a multi-user environment, and as such has to be Split into a Front End file, containing everything except the Tables, and a Back End file, holding the Tables. A copy of the Front End must reside on each user's PC and only the Back End, holding the data, can reside on the shared, network drive. I'm guessing from you statement

...The db file lives on the network...

that this is not the case.

Multi-users, working on a single, non-split Database, is going to lead to all kinds of problems, sooner or later, including the one you are currently experiencing, as well as data loss through corruption.

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[pdbowling]

I have more information from digging around. I found a SQL Server database by the same name as the MS Access db. Looks like Access is linked to the SQL Server db.

I found a security module with the function IsMemberOfSecurityGroups() that is called on the Form_Load() method of new windows. This Form_Load method is where the 'you do not have access to this form' message is generated after receiving false back from the IsMemberOfSecurityGroups method. Looks like I need to make the user a member of a group with access to the form..... but where do I do that? The user does not appear to be in the Security->Users list in SQL Server.

SQL Server 2008 is the linked db version.

Thanks for any advice.

 

[pdbowling]

Found some more info. Looks like it is using LDAP. Now that I know this, it is an Active Directory issue now so no longer relevant to this forum.

Thank you all.
Patrick B