everything is slow!

[Andy G]

Saving forms, opening forms, doing anything is super slow!!! Have a back
end and front end with linked tables. It just started being real slow.
Biggest table is like 3000 records and backend is maybe normalized to 2NF.

Any ideas?

 

[Allen Browne]

3k records is tiny for Access.

Tony Toews has a Performance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm

Work through each item, until you identify the bottleneck.

 

[Andy G]

I understand that...even more reason it shouldn't be giving me these issues.

 

[antman142 via AccessMonster.com]

I understand that...even more reason it shouldn't be giving me these issues.

3k records is tiny for Access.

[quoted text clipped - 9 lines]

what kind of environment are you in? Like Corporate vs. small business.
In the corp. world you maybe limited as to what you can do, due to IT
restrictions.
To start, I would check these first:
1.Turning off Name Auto-correct
2.Changing [Auto] to [None] in your table properties
KB article 261000 shows you how to do it with code.
3.Shorten DB names FE/BE to 8 characters
then go see KB Article 891176; then follow the directions; the code shortens
the pathway for your
linked tables.
4.Then after all that (or even before) Compact/Repair your DB.

Antman