W
Willem
Hi,
On a SQL Server 2000 there is a stored procedure with
parameters.
The front end is an Access 2002 mde.
I use a pass-through query as the recordset for a
continuous form.
To delete a record you select a record in the continuous
form and execute a second pass-through.
This second one is a stored procedure DELETE FROM table
WHERE ID = @ID
This results in a locking error.
If I just use the delete stored procedure without opening
the form, there is not locking.
Most of time it works to scroll to the last record and
back to the first. Then run the delete stored procedure.
I read about 'fetch' but don't understand the whole
scope.
Can someone help me?
Thanks
Willem
On a SQL Server 2000 there is a stored procedure with
parameters.
The front end is an Access 2002 mde.
I use a pass-through query as the recordset for a
continuous form.
To delete a record you select a record in the continuous
form and execute a second pass-through.
This second one is a stored procedure DELETE FROM table
WHERE ID = @ID
This results in a locking error.
If I just use the delete stored procedure without opening
the form, there is not locking.
Most of time it works to scroll to the last record and
back to the first. Then run the delete stored procedure.
I read about 'fetch' but don't understand the whole
scope.
Can someone help me?
Thanks
Willem