I have a front end and a backend to my access database. The VBA code, forms, queries etc are on the frontend and tables on the backend. The backend is on a server, about 5 different users are using copies of the frontend on their local.
When they change or enter some data, it shows/reflects quite instantly in the table in the backend, however that data is not available immediately in the forms. I am not sure why that is happening. I can see the updated data eventually in the forms but not immediately like I can see in the tables. (Ex-lets say a combobox that fetches data from a table in the backend).
Is there a table or query I can use/modify to see how often my database gets refreshed (both for tables and forms)? Also I want to improve the performance of my split database, it works really slowly right now. Any leads would help.