Re: Multiple backends and relationships
Hi Matt, at the least I would look into combining the backends into one. But the real reason I am responding is to hopefully impress upon you the SQL Server option.
If you have 40+ users then it is probably safe to assume your application is beyond a mere gadget that is “nice to have” and is a viable tool your organization values.
If I have that bit right, then it absolutely imperative that you migrate your BE to SQL Server. Although it may or may not increase performance (for me it did), the risk of corruption is all but eliminated. Additionally, the Maintenance Plans the SQL Server offers such as backups, integrity checks, index rebuilds and others make it a necessity.
It took me about 2 years and a near catastrophe for them to come around, but they did and life has been a slice since then.
As a rule, I do a compact and repair once a month prior to re-deploying the front end to my users and a complete decompile once a year. It could be my imagination but I swear my application started running faster after I started this regimen.
Best of luck...
- Ciao, John