Locking problem SQL Server MS Access mde

[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

 

[MGFoster]

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.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It seems the record you are looking at & want to delete is locked
(because you are looking at it?). Perhaps you should use a disconnected
recordset as the form's Recordset? Then when you issue the delete
command the record won't be locked.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQH2wpYechKqOuFEgEQKGrgCcD/Qb4pQRU8WjJyasgFCm57kmFF4An1Bf
AmbReYsUrL1eawatUejHlkjv
=iRui
-----END PGP SIGNATURE-----

 

[Vadim Rapp]

Hello Willem:
You wrote in conference microsoft.public.access.adp.sqlserver on Wed, 14
Apr 2004 14:10:29 -0700:

W> To delete a record you select a record in the continuous
W> form and execute a second pass-through.

W> This second one is a stored procedure DELETE FROM table
W> WHERE ID = @ID

You are trying to work with Access underlying data behind Access back.
Don't. Ask Access to delete the current record, and it will do it nicely w/o
any conflicts.

Vadim