By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,041 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,041 IT Pros & Developers. It's quick & easy.

Query Slows Form Design

P: n/a

I have a pretty intense query behind a form. I know that I need to
somehow make the query better. We are looking at those options.

I noticed that the form is really really slow in design mode.
Everytime I change or edit a control there is a long lag.

Is the query "looked at" while designing? What's with the lag?

Thanks,
Brian

Nov 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
a few things you might look at:

is the database on a server? better if you can make design changes with the
file on your hard drive, and copy to the server when done.

do you compact (and back up) your database frequently when making design
changes? if not, you should.

if you're using A2000 or newer, have you turned *off* the Name AutoCorrect
option in your database? if not, suggest you create a new blank database,
immediately turn off the Name AutoCorrect option, then import all the
objects from your current database into the new one. then compact the new
db, and back it up. for more information, see
http://home.att.net/~california.db/tips.html#aTip3.

hth
"BerkshireGuy" <bd*****@yahoo.comwrote in message
news:11*********************@f16g2000cwb.googlegro ups.com...
>
I have a pretty intense query behind a form. I know that I need to
somehow make the query better. We are looking at those options.

I noticed that the form is really really slow in design mode.
Everytime I change or edit a control there is a long lag.

Is the query "looked at" while designing? What's with the lag?

Thanks,
Brian

Nov 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.