I have a split database that runs somewhat slower than it does when it's all together. Users have front ends, the back end is on the server. Linked tables work fine. However...the main form is an "Appointments" form and it's not only slow to open up, but the drop-down boxes (based on select statements in the source property) don't display the options for each record. When they create a record and then move to another record and back, all the options show up...but only for that record.
It must be that when a new record is created, for some reason in the drop down's sql -- it's not executed right away.
How can I speed up the split database and get the drop downs to work?
Start Free Trial
