Why did it become slow

P

Pietro

Hi,

I'd a form called CAP,it was working fine and fast,suddenly it became
very slow when it opens,or when users click on a checkbox,although the event
put in the OnClick event of this checkbox is very simplE.
Please advise.
 
A

Arvin Meyer [MVP]

Pietro said:
Hi,

I'd a form called CAP,it was working fine and fast,suddenly it became
very slow when it opens,or when users click on a checkbox,although the
event
put in the OnClick event of this checkbox is very simplE.
Please advise.
Click to expand...

Without knowing anything about your database or version of Access, we can't
be specific. Here are some performance tips though:

Performance:
http://www.granite.ab.ca/access/performancefaq.htm
 
J

John W. Vinson

Hi,

I'd a form called CAP,it was working fine and fast,suddenly it became
very slow when it opens,or when users click on a checkbox,although the event
put in the OnClick event of this checkbox is very simplE.
Please advise.
Click to expand...

Presumably because there's something wrong. Since we cannot see your database
it is more than a bit difficult to advise!

Try using Tools... Database Utilities... Compact and Repair to see if that
helps. Also check out the suggestions at
http://www.granite.ab.ca/access/performancefaq.htm
 
P

Pietro

I'm using Access 2007 and my database format is 2000
the size is 120 MB,what else should i provide?
 
Top