Hi.
I have been using an Excel file to add, edit or delete data to an Access database. I run to a problem when someone else tries to commit any changes at the same time with me. Is there a way for my code to check if a .laccdb locking file already exists in the folder where my Access database resides and tell me that someone else is already "in it"?
Thank you.
I have been using an Excel file to add, edit or delete data to an Access database. I run to a problem when someone else tries to commit any changes at the same time with me. Is there a way for my code to check if a .laccdb locking file already exists in the folder where my Access database resides and tell me that someone else is already "in it"?
Thank you.
