Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / January 2004

Tip: Looking for answers? Try searching our database.

Access speed across a network

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin Newman - 30 Jan 2004 08:20 GMT
Odd one this - A N Other consultant (whom I know and repect) has developed a
multiuser (4 or 5 simultaneous users) Access database that runs on a network
I support.  "Traditional" backend front end split. (This is a "proper" SBS
2k network, not a peer to peer, by the way). ALl clients running WIndows and
Office XP.

We have had contuinual problems with speed on some machines but not all on
some queries.  We have increased memory, I have even changed the NIC on one
of the machines wondering if the problem was network speed (although it
never really looks like the NICS get streteched judging by the Netwiork
Utiliation applet or whatever its called in XP so that was always unlikely)

Now it just struck me taht the machines woith problems are Celerons, and the
others where we have no problems are "full" pentiums.  Has anyone ever
noticed a big difference running large queries bewteen  Celerons & Pentium.

(And before you say it I know we should move this to porprer client server
using SBS SQL backend but that is not presetly an option for various
reasons).

TIA
gandalf - 30 Jan 2004 15:38 GMT
you might check the performance FAQ on
http://www.granite.ab.ca/access/

Access version?
Service packs, jet updates, os updates?
"Speed" of celerons?

>-----Original Message-----
>Odd one this - A N Other consultant (whom I know and repect) has developed a
[quoted text clipped - 20 lines]
>
>.
Paul Overway - 30 Jan 2004 20:02 GMT
While celeron vs pentium at same speed may make a small difference, I've
found that memory makes a bigger difference....after you have made sure to
optimize the app to the maximum extent possible.  Tony Toews' site has quite
a few good tips.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com

> Odd one this - A N Other consultant (whom I know and repect) has developed a
> multiuser (4 or 5 simultaneous users) Access database that runs on a network
[quoted text clipped - 17 lines]
>
> TIA
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.