form takes an age to close after new data

[steve-oc]

I have a form frmPerson and a sub on that form subLinkedPerson. The records on the sub are filtered via the Person_ID. There is a button on the main form to bring up a list of contacts, upon which you can choose one and run a line of SQL to link the new conatct to the main person_id, the subform then requeries and the newly added contact is displayed on the subform.

This all works fine but once you add or remove contacts from the subform (via the SQL) and close the form it takes a good 30 secs to exit. Whereas when you open the form and don't change any data it closes as quickly as you would expect. There's no code at all that runs when the from closes, unloads, etc. I don't see how updating the data would have any impact on the from closing AFTER the data has clearly been changed - any ideas??? A2000 with back end tables.

many thanks!

 

[Rusty]

Hi Steve,

Firstly are the forms based on queries or tables? It's better if they are based on queries. This may or may not affect the exit time of the form.

In the meantime you could "Compact and Repair" the database and see if this makes any difference. Go to TOOLS; DATABASE UTILITIES; COMPACT AND REPAIR DATABASE...

If it doesn't perhaps attaching the d.base would be an idea - give us something to work with.

Rusty

 

[steve-oc]

hi - thanks for that. my forms are based on queries and have run compact & repair. as a test i have merged the front end & back end back together and everything works much quicker and runs smoothly. so am positive that the perfomance issues are wth the splitting and runnng acroos the network. do you guys have any advice about running beack end/ front end set-ups across a LAN ideally maybe 6 users runnng local front ends similtaneously.
thanks!