I have created a local user interface that uses a number of linked tables from a shared access database on a network server. When I try and add/modify records from the UI to the linked tables on the server (from a form) I get the "Operation must use an updateable query." error message.
Problem solving so far:
- Checked to make sure I had read/write/create access to the shared network folder.
- Ensured that the tables in question were indexed with a primary key.
- Opened the shared network database directly and added/edited records from the same computer that I am testing the UI on (in other words simply reconfirming the access noted under point 1).
- Added the local and shared folders to the databases trusted locations.
I have worked with Access for years and never stumbled across this situation previously.
Further information - UI is installed on a Win 10 machine and the shared db is on a Win 7 machine.