Network Connection In A Split End Database Is Constantly Interrupted nouveauricheinvestments[ at ]gmail.com 12/9/2008 3:55:02 PM Hi, I have a split database with about 60 front end users and today I have had users get messages stating constantly that their network connection is interrupted. I have spoke with my IT department and our switches have not been having any problems today. What else could cause an interruption in the database connection to the network?

Re: Network Connection In A Split End Database Is Constantly Interrupted "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> 12/9/2008 8:46:46 PM nouveauricheinvestments[ at ]gmail.com wrote: [Quoted Text] >I have a split database with about 60 front end users and today I have >had users get messages stating constantly that their network >connection is interrupted. I have spoke with my IT department and our >switches have not been having any problems today. What else could >cause an interruption in the database connection to the network? What is the exact message? "Disk or Network Error"? If so it's very likely to be hardware. Given that multiple users are having this problem that makes it even more likely. Is a network cable running over top of fluorescent lighting ballast? Although why that would be happening just today is a mystery. Tony -- 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/

Re: Network Connection In A Split End Database Is Constantly Interrupted nouveauricheinvestments[ at ]gmail.com 12/9/2008 10:04:17 PM On Dec 9, 1:46 pm, "Tony Toews [MVP]" <tto...[ at ]telusplanet.net> wrote: [Quoted Text] > nouveauricheinvestme...[ at ]gmail.com wrote: > >I have a split database with about 60 front end users and today I have > >had users get messages stating constantly that their network > >connection is interrupted. I have spoke with my IT department and our > >switches have not been having any problems today. What else could > >cause an interruption in the database connection to the network? > > What is the exact message? "Disk or Network Error"? > > If so it's very likely to be hardware. Given that multiple users are > having this problem that makes it even more likely. > > Is a network cable running over top of fluorescent lighting ballast? > Although why that would be happening just today is a mystery. > > Tony > -- > 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 athttp://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ It says the network connection has been lost. Please close down the access application and restart it. It is something to that affect. We haven't gotten it since this morning, so I'm not sure of the exact wording..this isn't the first time it has happened though. and it's not like we are a small company either. we have about 50 people in our IT department..they are all MySQL people though - they don't do much with access..

Re: Network Connection In A Split End Database Is Constantly Interrupted "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 12/10/2008 3:53:27 AM "Tony Toews [MVP]" <ttoews[ at ]telusplanet.net> wrote in news:r6mtj4p75qeokdj6uglit79jp4qjpreif9[ at ]4ax.com: [Quoted Text] > > nouveauricheinvestments[ at ]gmail.com wrote: > >>I have a split database with about 60 front end users and today I >>have had users get messages stating constantly that their network >>connection is interrupted. I have spoke with my IT department and >>our switches have not been having any problems today. What else >>could cause an interruption in the database connection to the >>network? > > What is the exact message? "Disk or Network Error"? > > If so it's very likely to be hardware. Or software. There are any number of software processes, on the server or on the workstation, that can interfere with network throughput. That could include a virus scan that causes the connection to time out, or it could be something running on the server that causes it to fail to return the requested data. > Given that multiple users are > having this problem that makes it even more likely. Well, it could be a software problem on the server, and all users would experience it. Or it could be a software problem on identically-configured workstations. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/

Re: Network Connection In A Split End Database Is Constantly Interrupted nouveauricheinvestments[ at ]gmail.com 12/10/2008 2:26:30 PM On Dec 9, 8:53 pm, "David W. Fenton" <XXXuse...[ at ]dfenton.com.invalid> wrote: [Quoted Text] > "Tony Toews [MVP]" <tto...[ at ]telusplanet.net> wrote innews:r6mtj4p75qeokdj6uglit79jp4qjpreif9[ at ]4ax.com: > > > > > nouveauricheinvestme...[ at ]gmail.com wrote: > > >>I have a split database with about 60 front end users and today I > >>have had users get messages stating constantly that their network > >>connection is interrupted. I have spoke with my IT department and > >>our switches have not been having any problems today. What else > >>could cause an interruption in the database connection to the > >>network? > > > What is the exact message? "Disk or Network Error"? > > > If so it's very likely to be hardware. > > Or software. There are any number of software processes, on the > server or on the workstation, that can interfere with network > throughput. That could include a virus scan that causes the > connection to time out, or it could be something running on the > server that causes it to fail to return the requested data. > > > Given that multiple users are > > having this problem that makes it even more likely. > > Well, it could be a software problem on the server, and all users > would experience it. Or it could be a software problem on > identically-configured workstations. > > -- > David W. Fenton http://www.dfenton.com/ > usenet at dfenton dot com http://www.dfenton.com/DFA/ Is there anything you would recommend I do to more precisely pinpoint the origin of the problem David?

Re: Network Connection In A Split End Database Is Constantly Interrupted "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 12/14/2008 4:21:20 AM nouveauricheinvestments[ at ]gmail.com wrote in news:e0329a13-c2fd-4868-a99b-fe11fc5e06d9[ at ]s16g2000vbp.googlegroups.co m: [Quoted Text] > On Dec 9, 8:53 pm, "David W. Fenton" > <XXXuse...[ at ]dfenton.com.invalid> wrote: >> "Tony Toews [MVP]" <tto...[ at ]telusplanet.net> wrote >> innews:r6mtj4p75qeokdj6uglit79jp4qjpreif9[ at ]4ax.com: >> >> >> >> > nouveauricheinvestme...[ at ]gmail.com wrote: >> >> >>I have a split database with about 60 front end users and today >> >>I have had users get messages stating constantly that their >> >>network connection is interrupted. I have spoke with my IT >> >>department and our switches have not been having any problems >> >>today. What else could cause an interruption in the database >> >>connection to the network? >> >> > What is the exact message? "Disk or Network Error"? >> >> > If so it's very likely to be hardware. >> >> Or software. There are any number of software processes, on the >> server or on the workstation, that can interfere with network >> throughput. That could include a virus scan that causes the >> connection to time out, or it could be something running on the >> server that causes it to fail to return the requested data. >> >> > Given that multiple users are >> > having this problem that makes it even more likely. >> >> Well, it could be a software problem on the server, and all users >> would experience it. Or it could be a software problem on >> identically-configured workstations. > > Is there anything you would recommend I do to more precisely > pinpoint the origin of the problem David? Well, it entirely depends on the nature of the problem. You need to determine which machines it's happening to and then try to find commonalities. There's no magic recipe. I've recently been through this with a client running SQL Server (and the dropped connections weren't limited to Access), and we've never been able to pin it down -- all brand-new wiring within the last year, all NICs replaced, two PCs replaced, one PC rebuilt from scratch, server software reconfigured multiple times, server NIC replaced, network switch replaced, all patch cables replaced, AV software replaced, etc. The problems all seem to lead back to the server itself, and it's due for retirement, so we're replacing it in the next month or so and see if that fixes the issues. If not, well, who knows. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/