I work with a highly programmed Access
database (some 15,000 lines of VBA code, much of it automating data
entry on forms -- and believe me, it's very tight code). In Access
97,
2000, 2002, and 2003, no performance problems. However, when I open
the same database in Access 2007, it's as slow as molasses. Data
trickles onto the form instead of an immediate display in Access
2003.
This happens regardless of whether I keep the Access 2002-2003 file
format or convert it to Access 2007. I have the recommended
1 GB RAM. I'm NOT using Office 2007 Beta. No missing references.
I'm beginning to notice more threads complaining of Office 2007
performance problems. Most often they seem to be tied to VBA code
execution. One example (for Excel 2007):
http://groups.google.com/group/micro...b163f9d22c9629
Any ideas?