Originally posted by Sia
After I splitt the db (access xp) the forms take for ever to open... very very slow. Do you know why?
Is there any way to improve it?
To test whether it is a network problem, copy both the front end and back end to the same computer, link the tables and then see if the sluggish behavior continues. If it does, please come back and let us know.
Having list boxes, combo boxes with queries, especially multi parameter queries, do slow down execution significantly. And adding network traffic to it just helps decreasing the speed of access to data. This is normal. And sometimes you may have to have them running.
Not knowing exactly how you have things set is making it difficult to make the best suggestion. But based on experience, I can tell you this: Have only your tables in the network when you have it split. Make your forms, queries and reports run at local computers. Hopefully this will add some speed to your application.