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 / May 2007

Tip: Looking for answers? Try searching our database.

Backend On Desktop

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill - 11 May 2007 00:14 GMT
In a multi-user environment, is it possible to place the backend onto a
desktop with Windows 2000 Pro?

I tried it and when a 2nd user logs into the database their performance is
terrible.

Thanks,
Bill
Armen Stein - 11 May 2007 03:23 GMT
>In a multi-user environment, is it possible to place the backend onto a
>desktop with Windows 2000 Pro?
[quoted text clipped - 4 lines]
>Thanks,
>Bill

Access is a file-server database.  That means that the back-end, no
matter where it is located, is opened by the front-end just as if the
server was a simple hard drive.

The PC the back-end is on needs to be fairly fast, because it is
reading its hard drive and serving data across the network, but that's
about all.  It is not doing any Access processing.  In fact, Access
doesn't need to be installed on it at all.

So, the performance issue might be caused by several things:  network
performance, slow back-end PC, disk on the back-end PC being nearly
full, application design, etc.

Try each user separately.  If one is faster than the other, the
culprit might be the speed of the user's PC or network connection.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
Larry Linson - 11 May 2007 05:11 GMT
> In a multi-user environment, is it possible to
> place the backend onto a desktop with
> Windows 2000 Pro?
>
> I tried it and when a 2nd user logs into the
> database their performance is terrible.

Peer-to-peer networks do not allow as many concurrent connections as a
server in a client-server. That may, or may not, be the source of your
performance issue.

MVP Tony Toews has a lot of excellent performance suggestions at his site
http://www.granite.ab.ca/accsmstr.htm. Take a look at these...

 Larry Linson
 Microsoft Access MVP
Tony Toews [MVP] - 14 May 2007 19:14 GMT
>In a multi-user environment, is it possible to place the backend onto a
>desktop with Windows 2000 Pro?
>
>I tried it and when a 2nd user logs into the database their performance is
>terrible.

The first thing to try is the persistent connections fix.

The three most common performance problems in Access 2000 or newer
are:
 - LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
 - sub datasheet Name property set to [Auto] should be [None]
 - Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
  Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 
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.