Hi, im new hear and at access programming for a ear now. I'm looking for ways to improve response time on or access CRM here inwork. Currently we have a frontend(forms and queries) and a backend(tables) stored on the file server, the users here(about 25) use access on terminal server.
i was wondering would it be benificial to move the front end of the database to the terminal server to reduce network traffic each time the user opens a new form or report etc, To improve response time and increase productivity etc. Is it a case that the entire frontend is loaded into RAM when they open the application and it wouldn't matter where its being loaded from or would it be benificial to have it loaded from the local C:\ drive of the terminal server so there not loading it accross the network each time.
thanks in advance