Forum Discussion
Speed of Access across multiple states
I work for a small company that has locations in 3 states. The servers are at my site and I don't notice any speed issue when working with databases onsite. However, the other two sites experience si...
Thank you. I can confirm that front end is the queries, forms, reports, etc. and the back end is just tables.
I will have to familiarize myself with parameterized queries. I assume you would place those in the front end?
Regarding the subforms and subreports, Ironically, I have had multiple issues with dlookups in standalone text fields, so I recently switched to using multiple subforms instead. I'll have to investigate yet another option...
Thanks
I will have to familiarize myself with parameterized queries. I assume you would place those in the front end?
Regarding the subforms and subreports, Ironically, I have had multiple issues with dlookups in standalone text fields, so I recently switched to using multiple subforms instead. I'll have to investigate yet another option...
Thanks
With multiple subforms (often in a tab control), one technique is "lazy loading", as seen in the Northwind 2.* Developer Edition template. Search for ".SourceObject =".
Another technique is to base more-or-less static dropdowns on local tables that are occasionally synced with the BE.
The last one I will mention at this time is to upgrade to SQL Server BE (maybe the free entry-level Express Edition is good enough for you) and offload some processing to the server.
Another technique is to base more-or-less static dropdowns on local tables that are occasionally synced with the BE.
The last one I will mention at this time is to upgrade to SQL Server BE (maybe the free entry-level Express Edition is good enough for you) and offload some processing to the server.