<sc********@oaeusa.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
help!!
I have a form which contains 6 subforms, with check boxes which run
events that then update data on all the forms. the data is all on 1
table in a backend data base and the user works the form in the front
end.
I have compiled and compacted the front end, deleted command buttons
and cleaned up the code but the speed is almost unusable. The system
worked fine for the past year aand now just runs like a dog.
Any suggestions would be most appreciated
Thank you
Shane
You could try deleting all the linked tables in the front end and then
re-linking the tables. You could also observe whether the re-linking
process takes longer than expected. If so, there may be something else
involved. I just had a user complaining about speed which turned out to be
caused by anti-virus software scanning the backend when it is accessed. A
main menu form is always open and is bound to a single-row table in the back
end which means the delay occurs only when first accessing the database, but
that 25 second delay is enough to annoy.
To start your investigation, try moving the back end to the same folder as
the local front end (so no network is involved), delete and re-create the
attached tables, switch off any extra software such as antivirus and see how
it does for speed. If it is still slow, then it is not the network.