I am working in Access 2003 and hitting against an SQL Server for my data. I need to update data in a table that could be in uses by one of several other applications.
So, what I need to do is to check to see if a record is currently locked/in use before opening the VBA recordset to edit it. This way, if the record is available, I can:
Open it/lock it/update it/unlock it/be on my merry way/go eat a cheese sandwich.
If the record is locked/not available, I can:
Inform the user/wait/not bother/ do something else both in my code and in real life.
How might I be able to accomplish this?
Thanks in advance and........ Go!