D
Dunmarie
I have multiple users using an Access database (Interface) connecting to the
main Access database on a server. I have found that sometimes when updating a
record while another user might have the record open on a query Access just
ignores the update without returning an error.
Code:
' Change the Location in the [stock file] table
Serial = lvDetail.ListItems(LoopIndex1)
strSql = "Update [Stock File] " & _
"Set Location = 'Sold' " & _
"Where [Serial Number] = '" & Serial & "'"
db.Execute (strSql), dbFailOnError
CommitTrans
Is it possible to check the record to see if it is free before submitting
the changes or to get Access to return a error so I can trap the error?
I am not a programmer so please give me as much detail as possible with
examples.
main Access database on a server. I have found that sometimes when updating a
record while another user might have the record open on a query Access just
ignores the update without returning an error.
Code:
' Change the Location in the [stock file] table
Serial = lvDetail.ListItems(LoopIndex1)
strSql = "Update [Stock File] " & _
"Set Location = 'Sold' " & _
"Where [Serial Number] = '" & Serial & "'"
db.Execute (strSql), dbFailOnError
CommitTrans
Is it possible to check the record to see if it is free before submitting
the changes or to get Access to return a error so I can trap the error?
I am not a programmer so please give me as much detail as possible with
examples.