Good day, All. I would appreciate some guidance on a Linked Table Manager issue.
I have created two databases located on a shared drive that only my managers have access to (the shared drive) – one database is intended for managers which stores all the data – and the other is intended for employees’ data entries which is linked to and feeds the data into the manager’s database via the Linked Table Manager feature. Because employees don’t have full access to the shared drive, I created and granted access to a specific folder on the shared drive for them which now has only the employee database in that folder (and a shortcut which I will use to put on the desktops of our employee kiosks.
Now here’s the problem: when I test the employee database from my computer (logged on as the generic user that we use to logon on our kiosks), I am able to open the employee database; but when I log on to my computer as myself (as one of the managers), the employee database shows an error where it can’t located the manager’s database that it’s linked to. What’s even crazy is when I update the path (still logged on as manager) and refresh the links, it works ----- but then the generic user gets the same error when they try to open it after the manager refreshed the path. I know it sounds confusing, but it’s almost like one user refreshing the links cancels out the links for the other user.
I am sure there is an easy way to remedy this or even do all of this from one database with security in place, but I am not that Access-literate YET! Help!!!!!!!!!!