99% of performance is how the application is written. I suggest that you get a good book on how
to use Access with SQL Server (I'm no expert myself in this area, but things like only fetch the
data you need and not the whole tables etc). And also analyze the slow queries to see if you can
create supporting indexes etc.
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
Quote:> Dear Friends
> I have a small network of 24 users with three depatments.
> The data is not huge, I have 2.5 GB ram on the server and
> it Hardly use the 30% of the same.
> But still i get the complaints from the users that the
> acces to the server is slow. We ar using MS-Access as a
> front end.
> Please suggest what is to be done to increase the
> Thanks and best regards