Re: ADP, Application Role, and objects

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

J> Scenario 3 -  If I do NOT grant explicit permissions, but depend upon
J> the Application Role, the form does not find the object when it opens. I
J> get the following error:
J>    Run-Time error '2850':
J>    The record source '<source_name>' specified on this form or report
J> does not exist.

I tried the following:

1. created table1 with permissions granted to userA
2. connected as UserA, created a form bound to table1.
3. created another form Form2 with OnOpen event running currentproject.connection.execute 'sp_setapprole 'RoleA','secretpass' . Saved the form.
4. revoked permissions on table1 from UserA; granted them to RoleA
5. tried to open form1, it failed (as expected).
5. opened Form2, then closed it


Then I opened Form1, and it showed the records in the table correctly.

Vadim
----------------------------------------
Vadim Rapp Consulting
SQL, Access, VB Solutions
847-685-9073
www.vadimrapp.com 

.

Relevant Pages

  • Operation illegal on linked parameter
    ... Run-time error '20656'; ... the Crystal Report with the data opens up. ... The callee (server ) isn not available and ...
    (microsoft.public.vb.crystal)
  • Re: VB Error on opening plans
    ... Run-time error '-2147417848 ': ... You can check for auto-run macros by going to Tools/Macro/Macros and ... When the editor opens, display the Project ... the code window, then have an auto-run macro that you may or may not ...
    (microsoft.public.project)
  • Forms Coding
    ... I am getting a run-time error on a click event on a form. ... Below is the code that fires when I click a button on the ... Private Sub Command78_Click ... Below is the code on the form that opens ...
    (microsoft.public.access.formscoding)
  • Document Compare/Merge
    ... UserB opens the document for editing and when prompted due to the document lock, elects to save a local copy of the document and merge changes later. ... Both UserA & UserB make changes. ...
    (microsoft.public.word.docmanagement)
  • Error 3009
    ... I am running a function from the switchboard that opens ... The query finds duplicate addresses in TABLE1 then ... macro runs to check TABLE2 for existing addresses. ...
    (microsoft.public.access.formscoding)