Hi all. I have a split database which the front end is distributed to two other people for use.
On the front end, I have a navigation form that has buttons which open certain reports for users.
Recently I created a report called "Visitor Clearances" and tacked a button to access it from the same navigation. (all my other buttons on this page are currently working)
When any user clicks on my "Visitor Clearances" button I get the message, "The Database Engine Could not lock table "Contacts_TBL" because it is already in use by another person or object". However, no one else is using the database and I don't have this back-end table open.
It feels like the database is trying to open the back-end table before it opens the front-end report.
Has anyone experienced this before?
Thank you.