[AccessD] Recording Locking

[Ryan W]

Err.. well.. that method that still holds the records locked waiting on the
confirmation prompt.... was hoping avoiding the default delete confirm
dialog would bypass this.



On Wed, Jan 10, 2024 at 8:20 AM Ryan W <wrwehler at gmail.com> wrote:

> Well,
>   It  does look like I can override the default delete confirmation msgbox
> and avoid having to use a separate command button.  I guess I'll tinker.
>
>
> https://learn.microsoft.com/en-us/office/vba/api/access.form.beforedelconfirm(even)
>
>
>
>
> On Wed, Jan 10, 2024 at 8:17 AM Jim Dettman via AccessD <
> accessd at databaseadvisors.com> wrote:
>
>>
>> I'd use the code.
>>
>> Delete confirmations is global.
>>
>> Jim.
>>
>> -----Original Message-----
>> From: AccessD On Behalf Of Ryan W
>> Sent: Wednesday, January 10, 2024 9:08 AM
>> To: Access Developers discussion and problem solving <
>> accessd at databaseadvisors.com>
>> Subject: Re: [AccessD] Recording Locking
>>
>> Yes; that's the idea is to use code to run the delete after a msgbox (to
>> replace deletion confirmations). But can I turn off delete confirmations
>> just for this form, or just the global option? Or is my only option a
>> delete command button, instead?
>>
>>
>>
>>
>> On Wed, Jan 10, 2024 at 8:05 AM Jim Dettman via AccessD <
>> accessd at databaseadvisors.com> wrote:
>>
>> > I should have added to turn off delete confirmations, or you can do:
>> >
>> > Dim db As DOA.Database
>> >
>> > Set db = CurrentDb()
>> >
>> > With db
>> >   .Execute "DELETE * FROM xyz WHERE ????"
>> >   If . RecordsAffected = 0 Then
>> >      MsgBox "Error"
>> >   Else
>> >       Msgbox . RecordsAffected & " records deleted."
>> >   End If
>> > End With
>> >
>> > Set db = nothing
>> >
>> > Jim.
>> >
>> > -----Original Message-----
>> > From: AccessD On Behalf Of Jim Dettman via AccessD
>> > Sent: Wednesday, January 10, 2024 8:57 AM
>> > To: 'Access Developers discussion and problem solving'
>> > <accessd at databaseadvisors.com>
>> > Cc: Jim Dettman <jimdettman at verizon.net>
>> > Subject: Re: [AccessD] Recording Locking
>> >
>> > Think you've summed it up nicely.
>> >
>> > That's the way it works.
>> >
>> > Jim.
>> >
>> > -----Original Message-----
>> > From: AccessD On Behalf Of Ryan W
>> > Sent: Wednesday, January 10, 2024 8:43 AM
>> > To: Access Developers discussion and problem solving
>> > <accessd at databaseadvisors.com>
>> > Subject: [AccessD] Recording Locking
>> >
>> > Hey all,
>> >
>> > I had an interesting situation I don't think I've encountered before:
>> >
>> > I had a user come to me the other day and said they couldn't run one of
>> the
>> > calculation command buttons. I ran it and got a query timeout.
>> >
>> > I checked for blocking SPIDs and found the one blocking this.  I went
>> back
>> > to that workstation and the user had highlighted rows from a datasheet
>> and
>> > pressed the delete key but left the deletion prompt up and walked away.
>> >
>> > This left a transaction open that was blocking other users from
>> > modifying/inserting/deleting rows in the same tables, even if it was
>> > unrelated data.  I'm guessing the primary key column(s) were locked up
>> in
>> > all of this.  Once I hit OK or Cancel on that dialog prompt, the system
>> > returned to normal.
>> >
>> > The only 'fix' I can think to come up with would be to make a delete
>> button
>> > that uses a MsgBox and then runs the delete code on the selected rows,
>> > since that would only run AFTER the MsgBox OK button is pressed...  or
>> just
>> > tell my users "don't walk away from confirmation dialogs".
>> >
>> > Anyone got any words of wisdom on this?
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > https://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > https://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > https://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>