Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Access 97 performance dies

Author  Topic 

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2003-05-09 : 02:49:49
Hi guys,

We had a fairly static system running against a SQL 7. A system upgrade to SQl 2000, and the performance has entered the basement ! 10 minute queries now not finising in 2 hours.

I'm posting on behalf of the access guy - if canyone has any hints , I filter thro to him...

TIA

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!

X002548
Not Just a Number

15586 Posts

Posted - 2003-05-09 : 16:44:54
Did you do a Pef Mon on it when he runs the query to see if it's SQL Server (doubt it) or Access.

Anyone taking bets?

Also, why is a 10 minute query in access acceptable? I would think only as a "Batch" kind of thing.

And if that's the case, then why not do the administrative tasks in SQL to begin with.

AND if it is for OLTP, then you must have some VERY patient users.



Brett

8-)
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-05-09 : 16:46:18
Try re-linking the tables in Access. There's an add-in that will do this automatically for you called "Linked Table Manager" or something like that (tools-->add-ins).

Also, make sure your client has the latest version of MDAC installed.

- Jeff
Go to Top of Page

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2003-05-12 : 06:54:05
I'll check the re-linking.

These are OLAP-ish queries, hence the duration. The 10 minutes + component are indeed batch sections, but there are other's that were ... let's say sub-minute, that are now wounded ducks ...

It's a sad state of seomone pushing the "little ms access DB that could!" .. we don't want it, but it was rolled out to +-200 users (out of 1000) via "backdoor", and now we're stuck with it.

Sadly we are constrained to MDAC 2.6 due to pacakge constraint using same hardware...

Thanx guys

*#&#* *#&#* *#&#* *#&#*

Chaos, Disorder and Panic ... my work is done here!
Go to Top of Page
   

- Advertisement -