Slow query

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I have an access database that since moving to windows 2003
and office 2003 is slower than molasses flowing up hill in
January.

I have compacted the database, I have moved it to the local
machine, I have upgraded the DB to 2003, as the original is
2000, I have verified the latest version of JET is running,
I have run the sql query to the mysql db via Mysql CC and
it returns all 1000 rows in <10seconds.

Other ideas of things to check?

The enviornment is this:
13 Windows 2003 Terminal servers.
All users access a central server that contains the Access
DB vi a share. Help.. this is driving me nuts!
 
Does each user running a separate copy of the Front-End on the Terminal
Service server?
 

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

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
VBA Code to Connect and Query a MySQL Table 12
ODBC Connector to MySQL server 2
Access networking slowness 3
Update query fails due to lock violations 3
Access freezes or hangs attempting to open linked ODBC tables 1
Compacting Access database 2
Access for MySQL data reports only 5

Back
Top