If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What's with Access 2003? Very Slow!
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. |
#2
|
|||
|
|||
What's with Access 2003? Very Slow!
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 -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.attcanada.net/~kallal.msn |
#3
|
|||
|
|||
What's with Access 2003? Very Slow!
"Albert D. Kallal" wrote:
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 |
#4
|
|||
|
|||
What's with Access 2003? Very Slow!
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 "eagletender" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|