 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / May 2007Affect of shared backend
I have an application that has a separate backend mdb for the data. Recently we put the backend on a server. 4 different computers run the application mdb, located on each PC. All seems fine with one exception. One of the forms takes about a minute to open (to even reach the Open event!) IF another PC already has that same form open. This does not happen unless they are both using the shared back end. I can't imagine how this is happening with just this one form. The speed of opening the application database is not affected. No other forms are affected. And since this slowdown happens before the Open event is executed, it's not even hitting the shared database. Any ideas? > slowdown happens before the Open event is executed, it's not even hitting Probably because you have a subform. Subforms query before the open event. Or possibly a combo box Apply all service packs to the server. Turn off packet signing at the server. Remove the form from the subform control. In the Load event, set the form property of the subform control. Decompile, compact and save the database. Compile and save the database. (david) > I have an application that has a separate backend mdb for the data. > Recently we put the backend on a server. 4 different computers run the [quoted text clipped - 6 lines] > slowdown happens before the Open event is executed, it's not even hitting > the shared database. Any ideas? There is no Access on the server. Are you talking about OS service packs? I don't know what you mean by "turn off packet signing". Could you give a script for how to do that? There is no subform, but there are combo boxes. Anything I should do about them? I don't know what you mean by "decompile." Script? >> slowdown happens before the Open event is executed, it's not even hitting > [quoted text clipped - 24 lines] >> slowdown happens before the Open event is executed, it's not even hitting >> the shared database. Any ideas? Access MDB is unreliable move to SQL Server and just use Access DAta projects > There is no Access on the server. Are you talking about OS service packs? > [quoted text clipped - 37 lines] >>> hitting >>> the shared database. Any ideas? Everyone please note that Aaron Kem.pf is attempting to impersonate one of our regular posters again. Tom would never post such a message. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. > Access MDB is unreliable > [quoted text clipped - 44 lines] >>>> hitting >>>> the shared database. Any ideas? >I don't know what you mean by "turn off packet signing". Could you give a >script for how to do that? See the Disable Server Message Block (SMB) Signing section at http://www.granite.ab.ca/access/performancefaq.htm >I don't know what you mean by "decompile." Script? Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times http://www.granite.ab.ca/access/decompile.htm Tony  SignatureTony 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/ You have some good suggestions. I would do two things: 1) try the persistent connection trick. Open up a front end, then simply open up any table (that is linked to the back end), now, minimize that table...now launch that form...... If the above fixes this, then you can setup a form, or code to force to keep the connection open. The next list of things to try is here: http://www.granite.ab.ca/access/performancefaq.htm SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com |
Reply to this Message |
 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.