J
JoelB
I have a form that works fine for updates and deletes, but when I try to
insert a new record as a non-sysadmin, I get this error:
Invalid input parameter values. Check the status values for detail.
In Profiler, the last thing before the error is the sp_prepare statement for
the insert.
I am familiar with the issue with identity columns (this table is using one)
and views, however in this case the form is bound to a stored procedure, and
the stored procedure (and resync) both tie directly to the table, not to a
view.
The other interesting thing is that the insert works fine when I grant the
user sysadmin server role. Using Profiler I captured the insert that follows
the sp_prepare. I then removed the user from the sysadmin role, and ran the
insert from SSMS as that user and it worked fine.
The user normally has access to the tables through datareader/datawriter
roles, and can insert data in other forms in that same ADP.
Can someone help?
TIA,
Joel
SQL 2005 (9.00.3073.00) and Access 2003 SP3.
insert a new record as a non-sysadmin, I get this error:
Invalid input parameter values. Check the status values for detail.
In Profiler, the last thing before the error is the sp_prepare statement for
the insert.
I am familiar with the issue with identity columns (this table is using one)
and views, however in this case the form is bound to a stored procedure, and
the stored procedure (and resync) both tie directly to the table, not to a
view.
The other interesting thing is that the insert works fine when I grant the
user sysadmin server role. Using Profiler I captured the insert that follows
the sp_prepare. I then removed the user from the sysadmin role, and ran the
insert from SSMS as that user and it worked fine.
The user normally has access to the tables through datareader/datawriter
roles, and can insert data in other forms in that same ADP.
Can someone help?
TIA,
Joel
SQL 2005 (9.00.3073.00) and Access 2003 SP3.