Originally Posted by
Ajax
that setup with multiple users will lead to corruption. It may already have started in some small ways, but at some point it will get to a point from which it cannot recover and you have lost everything, subject to restoring a backup (which itself will be corrupted, just not as much)
1. The db needs to be split into frontend and backend. The backend contains tables only, the front end forms/reports/queries and code/macros. There are plenty of thread on this and other forums + ms where you can find how to do this
2. once the db is split, the backend is located on your server and each user must have their own copy of the front end on their local machine, linking to the backend on the server. Again there are plenty of threads on how to do this and how to manage updating front ends on multiple machines.
the refresh interval setting you are talking about refers to refreshing linked tables, so will have no effect in your current setup.
As to why users are not seeing updates to tables when they run the query, they should see them so it is probably an early sign of corruption setting in. If you are talking about refreshing a query which is already open, you need to use a timer event on a form to refresh the query.