That's just silly. Garbage in garbage out.
DB engines don't have packed inspection.
When the data stream gets to the engine, it is no longer a packet.
It has been assembled into coherent data at the workstation by the
Nic/network software layer.
----- Original Message -----
From: "MDRD" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, August 19, 2010 3:31 PM
Subject: [RBASE-L] - RE: Corrupt DB
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
