I have an application that is reading backend data off a server and now with 3 users on the network the lag time between the user asking for data and the screen refreshing with the data is very slow.
The backend holds only the tables with the data,
The front end holds everything else.
what we noticed is the data being received back to the user from the backend is in the 3mb range (while the data xfer to the backend server is in the 20kb range.
This explains why the user's request seem to get to the server quickly but the reply back from the server seems to lag a long time. From what i understand this is because the user is requesting some data off the server through a query that is on the front end. The query is accessing a data off of a couple of tables that are stored on the backend. I believe the backend is sending a the whole dbase back to the front end - which filters it through the query showing the user the requested data. If this is what is happening it would make sense to run the query on the server (backend) and only send the user the filtered data (much smaller amount of traffic). The problem with this is Access doesn't seem to allow you to link to queries that are stored on a backend database (you can only link to tables).
So how do you get the file size lower on the receive side of the transaction? Is there a way to query the data on the backend before sending back to the user over the network?
I only have 3 users on the network and i have 4 backend data files each smaller than 33kb in size. Front end is 90kb in size. Backend data is .mdb format, front end is .accdb format
thanks
Steve