I have a user that has an Access database configured to have all of the forms, report, and dashboard in one database and the data tables residing in a separate database.
I can see when the initial dashboard database is open, the locking file is created for that file. When you go an open a form, you can see an additional locking file created for the backend database.
There is only one other person in the office that needs to be able to open that database and see the changes. I have tried copying the "front-end" database to the user's desktop and connecting to the "back-end" database on user 1's system? When I go into Linked Table manager to point to that file, I don't see that "back-end" file. I can see the front-end and back-end mdb files on user 1's system, but only the front-end database on user 2.
What am I missing here? How should I be setting this up?
Thank you for any help that you can provide.