Forms take forever to open

[Bonnie]

Hi there. Using A02 on XP. Saw a post a few weeks ago and
didn't print it, wish I had. Someone asked what could
speed up forms opening and the answer given was to change
some setting that worked even though it didn't seem
related to the problem. Sorry I'm being vague but perhaps
the experts know just what I'm referring to? Thanks in
advance for any illumination...

 

[Roger Carlson]

Check out this site:
http://www.granite.ab.ca/access/tipsindex.htm

and look for the Microsoft Access Performance FAQ

 

[Jason]

Basic answer: When a form opens it retrieves all the records in the
underlying table or sql statement.

Change your sql statement to retrieve only the records you need.

or

If you are just adding new records then set the form property
dataentry=yes.

Last if this is an ADP project set the maxrecords property equal to
some reasonable number. By default it is set to 10,000 records.

Hope this helps,

Jason

 

[Bonnie]

Perfecto! Thanks bunches, Roger. Exactly what I needed.

 

[Peter De Baets]

This link mught help: http://www.granite.ab.ca/access/performancefaq.htm

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com