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 / March 2008

Tip: Looking for answers? Try searching our database.

Access 97 with SBS 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Georg - 27 Feb 2008 11:09 GMT
I am using a VB 6 application with DAO 3.51 Jet Engine. The database is
located on a Server. I have changed the old server (Windows NT 4) to a new
Windows 2003 small business server.
With the old NT server saving an invoice (within a transaction) was 5 to 10
times faster than with the new server. Both servers are domain controllers.
What as changed?
david@epsomdotcomdotau - 01 Mar 2008 08:22 GMT
Signed network packets (a security measure) require packet
serialisation, which means each database lock has to wait for
the previous database lock to go the server and back again.

SBS has network packet signing turned on by default because
it handles user profiles, including group policy objects.

Sometimes you can get most of your speed back by going
through and doing other optimisations. Look at Tony's
Access pages for suggestions:
http://granite.ab.ca/access/performancefaq.htm

(david)

> I am using a VB 6 application with DAO 3.51 Jet Engine. The database is
> located on a Server. I have changed the old server (Windows NT 4) to a new
> Windows 2003 small business server.
> With the old NT server saving an invoice (within a transaction) was 5 to 10
> times faster than with the new server. Both servers are domain controllers.
> What as changed?
 
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.