access extremely slow when certain actions are done

[tacexpo]

I've updated few things(new table, added some fields, new forms, etc) to this database and now it acts really slow on some parts.
one example is when i click on the combo box.
im not sure if it's because it's populating 3000 records..
can that be why?

 

[seaport]

If the combo list contains 3000 records it might be the reason. Make sure that the query for the combo rowsource contains fields only you need for the list. Also, if the query is sorted in any way, add an index to the source table.

Check out the following links. They might help.

Improving Performance of an Access Database

http://office.microsoft.com/en-us/access/HP051874531033.aspx

Information about query performance in an Access database

http://support.microsoft.com/kb/209126

http://www22.brinkster.com/accessory/wip.shtml

Seaport

 

[tacexpo]

thank you