Search results

I have a split database with a single back-end accessed from two identical copies of a front-end. The back-end and front-ends are all located on a 1Gbps LAN. In this configuration, performance is abysmal because all query execution happens on the front-end systems, and involves shipping all...

Thanks for all the excellent info. The automatic front-end update might be doable. There will be issues when a combined BE/FE upgrade is pushed, and some clients still have a running FE instance that's no longer compatible with the new BE table structure... I guess checking the "required...

I understand that's one canonical solution, but it isn't optimal when pushing out FE updates. I want to understand the actual source of the problem to determine if the no-tables solution will work.

I have to update a split Access DB from single-user to multiple users. All persistent data is in the BE, FE contains the app plus a few tables that would be TEMPORARY if Access supported the concept. The client has access only to the runtime, not the development environment. I see three...