|
Answer» Hello all, Here is my problem. I am running Access 2003 front end and back end (it's a split db). I have as many as 12 connections to the db at any one time. The db keeps deleting records and I have been told it could be due to bad connections, faulty interface cards, bad or faulty hubs and switches. I am looking for recommendations on software and or hardware that I can use to track down the problem. This problem has just started within the past month. Any help would be appreciated. Thanks in advance.ftp://Well, that's quite a widespread problem, could be a million things. Gonna need a lot more information.
You could start with some loop backs and cable TESTERS. Loops will help with testing the INDIVIDUAL cards, a cable tester will let you... you guessed it... test cables.
It seems the loss isn't 100% of the time, so as you're testing cables, work down the cable... kinda massaging it. If there's a problem or a break, it should show on the cable tester.
Before giving much more advice than that, we'd need to know the network setup, OSs, makes and models of the equipment... everything you can provide, there's never too much information.My setup is as follows: 1 server hp Proliant ML370 with 2 GB memory and raid 5 consisting of 3 72gb drives running MS Small Business Server 2003. With Exchange running, ISA 2004, the hole ball of wax. 1 Linksys EF2124 24 port switch 1 3Com switch 12 port for printers, scanners and other network devicesSorry about that hit wrong key. to continue: 3 hand built computers using MSI motherboards with AMD processors. All running Windows XP pro. these machines are all running on INTEGRATED NICs. They have the most uptodate drivers I could find. 8 Dell computers Each running off internal NICs. They have a COMBINATION of AMD and Intel processors 5 are running Windows 2000Pro the other 3 are running Windows XP Pro. 2 Hand built computers running Windows 2000 server housing only electronicly scanned files. These have AMD processors. The oldest machines are the 2 hand built servers they are about 4 years old. My database is housed on a hand built machine with a Asus MB and an AMD processor with 512 MB of memory. Running Windows XP PRO. This machine has a 3Com PCI NIC card. If there is more info you need please let me know. Before moving to Access 2k3 the back end was running in Access 97 and the frontends were Access 2000.Every thing was A OK wiht this set up but then I hit the 1GB barrier of Access97 and had to move to newer version. Everything upgraded really well, all processes seemed to work ok. Had a couple of complie errors but FIXED them and recompl\iled with no errors. Then the deletions started. And that as they say is the rest of the story. I hope you can give em some guidence on this.
Again thnaks for your assistance.
|