Paul, Mike, Karen, Bill, Emmit ......All But could he say Access is a light weight and other more robust DB engines (SQL server) should be able to handle bad packets? Remember he use to be a MS tech where they charges $500 an hour to send him out to companies, at least that's how the story goes. Also I can not find much info on corruption that other DB, and the program that is trying to replace my App is SQL Exp.
I thought I read somewhere all client server DB's are less prone to network issues compared to file server DB's? Thanks... please keep the info coming, I plan on sending him all of this and I will CC my user too Marc From: Paul InterlockInfo Sent: Thursday, August 19, 2010 12:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Corrupt DB simple with Google and funny to see the list. Number One ! NETWORK CARDS (that includes wiring, switches, hubs <gig>, etc.. ) HARD DRIVES Google: db AND packets AND corruption Results: 1. Access/VBA Tutorials - Access Database Corruption Repair Guide Network cards that lose packets and hard drives that have bad sectors are highly likely to cause database corruption (as well as many other computer ... www.everythingaccess.com/tutorials.asp?...Database-Corruption... - Cached - Similar 2. 65518: Samba smbd process.c chain_reply Function SMB1 Packet ... Jun 18, 2010 ... Download DB. 65518 : Samba smbd process.c chain_reply Function SMB1 Packet Chaining Memory Corruption Printer | http://osvdb.org/65518 ... osvdb.org/show/osvdb/65518 - Cached 3. 5 Simple Tips To Prevent MS Access Database Corruption Remember that the corruption flag can be set from the slightest packet loss between your computer and the database file. MS Access has sometimes been called ... ezinearticles.com/?5-Simple-Tips...Database-Corruption... - Cached - Similar 4. Get IT Done: Top 10 ways to prevent Access database corruption Apr 2, 2002 ... Get IT Done: Top 10 ways to prevent Access database corruption ... collisions occur and so fewer packets have to be present across the wire. ... articles.techrepublic.com.com/5100-10878_11-1060083.html - Cached - Similar 5. Microsoft Access Database Corruption Issues Network cards can lose packets and hard drives can experience bad sectors which are contributing factors not only to database corruption but to other ... www.access-programmers.com/Scalability/CorruptionIssues.aspx - Cached Notice all but 3 is Access, and the list goes on. Give me a break, he has a hole in the bucket dear Johnny! Sorry for the rudeness and cut/paste but .. Perhaps you could send him a link? ? to Google? or Yahoo. Sincerely, Paul D ** Well on the bright side, thank you Google. If any rights/tm/patents were violated it was not the intention of this response and I apologize in advance. From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, August 19, 2010 1:06 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Corrupt DB Hi I have this one user that keeps getting corruption in this one table. For the most part this is the only office having a problem. They have a computer tech that is some hot shot MS certified network something or other and I am over my head in discussing what may be causing the problem. As luck would have it this office has a lot of influence with my other users so I really need to nail this down. They were able to add 1,100 rows of data since the last corruption, so I told the tech that I do not think it is RBase or my app also they are basically the only office having a problem. I suggested some kind of junk data in one of the rows and everytime they hit that row of data or that customer it corrupts the DB but I am only grabbing at straws. He sent me this... so how should I respond? I can find tons of links about Access corruption due to network issues, but is he talking about a CS db compared to file server db? >From a network standpoint, it cannot corrupt the database. The packets could >get corrupted, but then you'd have to ask why the program you use as the >engine for PS (this my app), then commits a corrupt packet of data...their >engine is the only thing that can modify the file. That is what I'm getting at >here...only they and the local hardware/3rd party software can modify that >dbase on the local machine. Or do they allow that other workstation to make >direct edits over the network? That would be crazy... Again, yes, the local hardware and third party software can indeed cause corruption to the physical file, but I would highly doubt it would happen at the same place/table of a Db each and every time. That is one if the things that says software/process about this. Can you tell me how their flow goes? How they edit from a client etc? I need to understand how the Db engine works. That will help whether it's software or hardware...it will tell us where and when to look. thanks for any help Marc
