none
help for Ms Access combo box only can be viewed by sa RRS feed

  • Question

  • I  have a Ms Access interface (which is connected to a sql Server database server),

    I create a new proc for one Access combo box and I used it in Access interface. It works fine if I log in as 'sa' but not other user. Other user can't see the combo box list at all.

    BTW, I grant the security for the user to execute the new proc.

    And it returns expected result when log in SQL Server Management Studio(SSMS) as other user.

    Please help me here!

    Thanks!

    Kathy

    Monday, November 2, 2015 7:34 PM

Answers

All replies

  • How you bind this SP to combo?

    Michał

    Monday, November 2, 2015 9:21 PM
  • Hi,

    Here is the info related to my combo box:

    Control Source is a SKey related field in a SubFrom related proc

    RowSource = a combo box subproc which return Skey, SText

    ColumnCount = 2   -- will be SText, which user will see

    BoundColumn = 1   -- which is Key (which is sKey in Combo box proc

    ColumnWidth: 0";2"

    Thanks a lot for your help!


    Tuesday, November 3, 2015 1:48 AM
  • 1. It's adp?

    2. RowSource is subproc or Stored Procedure?


    Michał

    Tuesday, November 3, 2015 7:39 AM
  • 1, Not Access Data Projects (ADPs)

    2. Row source is one layer proc

    If I show SKey field (ColumnWidth: 1";2"), I can see SKey and can edit it but I can't see the com box and use combo box edit the table value for that field.

    Thanks!

    Best regards,



    Tuesday, November 3, 2015 9:07 PM
  • Kathy,

    Something is wrong... I don't understand what is one layer proc?

    If you use defined function then rowsource is empty, and rowsourcetype is name of function.

    What exactly do you do?


    Michał

    Tuesday, November 3, 2015 10:40 PM
  • Hi,

    I already solved the problem. It's caused by row source not having dbo. before the combo box proc when I log in as 'sa'. Which lead to other user can't see this proc.

    Best regards,

    Kathy

    Wednesday, November 4, 2015 9:19 PM