Why did it become slow

[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.

 

[Arvin Meyer [MVP]]

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.

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

 

[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.

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

 

[Pietro]

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

 

[Arvin Meyer [MVP]]

In addition to the site below, try this as well:

http://www.allenbrowne.com/tips.html#Upgrade
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com