Upgrade to Access 2003 = poor performance

M

Mark

When I upgraded from Access 2002 to Access 2003 the query speed has been
reduced to a stand still.

Mdb2 runs queries using linked tables from mdb1. The CPU usage of Access
2003 flutters between 10% and 50%. In Access 2002 the needle on CPU usage
was pinned at 99%.

I tried changing the "subdatasheetname" property from [Auto] to [None] on
the the table source mdb1, the Access won't take the change. (I.e., when I
reopen the table in mdb1 after saving the change, it shows [Auto] in the
subdatasheetname property.

Any suggestions?

Thanks,
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2007 query performance 1
Linked SQL query performance after upgrade 97 to 2003 6
Changing ODBC Data Sources 1
Access 2003 to 2010 upgrade 1
Performance Problem of Query 3
Very poor performance with Excel 2007 3
Upgrade issue from Access 2000 to 2003 (Security messages) 1
Microsoft Access Performance Issues 4

Top