I use unbound fields in a form header in a continuous form to allow users to enter filter criteria. This work well.
However, this form doesn't allow changes to data (it's for users to select a row, which then opens in a dialog form), I want to set Allow Edits=False. When I do this, the...
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...