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

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

Answer 1

How you bind this SP to combo?

---

Michał

Answer 2

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!

Answer 3

1. It's adp?

2. RowSource is subproc or Stored Procedure?

---

Michał

Answer 4

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,

Answer 5

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ł

Answer 6

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