Thanks for the long version... I'll read that when I have a few hours to spare :w00t:.

mastroine (10/2/2007)

---

SELECT opinion_id, site_name, site_benefits

FROM tblMyOpinions_SitesILike

WHERE positive_opinion = 1

AND site_ranking = 1

...

Network permissions?

All the patches installed?

Can you install QA on that client and see if you can connect from there?

... or try that connection string from a vbs file maybe.

How does this bulk load work? Is this only a parameter you set or do you have to manually split the data file and call imports in parallel?

Consider going to a full ADP (Access Data Project). You can use all the usefull tools to create the interface and access still takes case of most of the...

Sounds a lot to me too... but I have no baseline for his server, and I have never had a deadlock happen (unless I tried to make one), so I'm...

I've never seen this file, can you clear something up for me?

You have a DNC list, hence (in my head anyways), you have a list of # to NOT call....

I'd go with profiler next. That will rule out the poor app design option and will even point you to the dead lock possibility.

I've not met a file or...

Indexes are not really usefull when you need to scan the whole table like that. Since you report no performance inprovement, I'd just drop the matter.

The real question is...

Agreed, but we don't have enough details to call bullshit... yet.

Also, if all the user PCs are slow for a particular application or even form, you might have a crappy application in place. Might be a good place to...

Checked the network?

Even with only 1 deadloack, you might have heavy locking, you may also have auto-close or auto-shrink on which may cause these types of problems (when the db...

One more thing to consider here, what is the cost of creating the index and what is the cost of not having in for the period between reloads.

As Sergiy said,...

Most of us just try to control ourselves... this is where most of the moderation comes from :)... That and Steve of course, when things get too much out of...

I see what you mean, but I don,t understand why you'd need to do this. Can you post the problem you are trying to solve with this solution?