What's with Access 2003? Very Slow!

[eagletender]

Does anyone else have the problem that any time a table design is modified,
it takes 45 seconds or more to close the table? This started happening when
I installed Office 2003, and it happens with previously-created databases
and new databases.

 

[Albert D. Kallal]

Hum, I have to assume that you are JUST changing from a2000, or a2002?

Or, is there more factors involved. (you are running new network, new pc's,
new OS (ie: now running windows xp).

There is a lot of possible issues here.

However, I can say that I have not seen any performance, or performance
issue that would make access 2003 any different then the last two versions.

I have certainly seen some virus software, and some issues when working on a
file across a network (is this your case?).

Try opening another table, and then minimize it. Now, try making changes to
your above table..and close...(I bet the delay goes away if you keep another
table opened).

For this trick, and others...check Tony'y faq on performance problems..and
fixes...likely a solution is here to fix your problem:

http://www.granite.ab.ca/access/performancefaq.htm

 

[Tony Toews]

Hum, I have to assume that you are JUST changing from a2000, or a2002?

Actually I'd suspect either new to Access or just changing from A97.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Larry Linson]

If your previous experience was with Access 97, a bit of "save shock" is not
unexpected. Access 97 and earlier saved only the object whose design was
changed; Access 2000 and later save the entire database (aka "monolithic
save") no matter which object is changed, or how small that change is.
Particularly if you have modestly large DBs, this can be a surprise.

The delay was longer in Access 2000 -- 2002 and 2003 still have the
monolithic save but they did make some speed improvements.

So, I would agree with Tony's assessment.

Larry Linson
Microsoft Access MVP