B
bcap
I'm using the well-established technique of parameterising combo box row
sources using an inline function or an sproc which has a parameter name
equivalent to the name of a form control.
What I've found in an Access 2003/SQL Server 2005 environment is that this
will only work if I'm logged on as a sysadmin. With any other user, I get
the following:
With an sproc:
"The record source <sproc name> specified on this form or report does not
exist"
With an inline function:
"Parameters were not supplied for the function <function name>"
I've tried, without success:
- giving the user *every* permission to the sproc, the function, and the
underlying tables
- qualifying the sproc or procedure name with the schema name.
The only thing that works is to log off, and log back on as a sysadmin.
This is a non-starter for a production system, I can't make every user a
sysadmin!
I realise that I can programmatically assign a query to the row source in,
e.g., the OnCurrent event, but this doesn't help where the combo box is on a
continuous form and the bound column is not visible.
Help anyone? Or is this just another nail in the coffin of ADP's?
sources using an inline function or an sproc which has a parameter name
equivalent to the name of a form control.
What I've found in an Access 2003/SQL Server 2005 environment is that this
will only work if I'm logged on as a sysadmin. With any other user, I get
the following:
With an sproc:
"The record source <sproc name> specified on this form or report does not
exist"
With an inline function:
"Parameters were not supplied for the function <function name>"
I've tried, without success:
- giving the user *every* permission to the sproc, the function, and the
underlying tables
- qualifying the sproc or procedure name with the schema name.
The only thing that works is to log off, and log back on as a sysadmin.
This is a non-starter for a production system, I can't make every user a
sysadmin!
I realise that I can programmatically assign a query to the row source in,
e.g., the OnCurrent event, but this doesn't help where the combo box is on a
continuous form and the bound column is not visible.
Help anyone? Or is this just another nail in the coffin of ADP's?