Corruption of data matrices.

[meekon5]

I'm running a forecasting system across a number of access databases. Unfortunately one of the databases has undergone heavy corruption of the data, but not in any logical method. I have run queries to find what extent data differs in the matrices and found some seventy lines have become illogically corrupted. The database itself still operates. I have checked for migration across parts (lines) but there is none. I have checked for trimming of numbers (i.e. 200 becoming 2, or 205 becoming 5). It's almost as if someone has lifted the file and replaced everything with a random number table. I am now at a loss as to how this has happened. Has anyone any ideas as to what could have caused this. The data matrices is of some 80,000 items which are manipulated by thirty different access databases. I fear it may just be human error, or just the size and structure of the project has reach disproportional levels and realy should have been ported to SQL server many months ago. But they don't listen to me do they!

 

[DougP]

First of all, corruption of a database usually refers to when you cannot open it cause you get a serious error.
If you can open it then there is NO corruption.
I suspect since you say the data is manipulated by 30 databases, that it your problem. One or more of those are wrecking your data.

So you have to begin the slow tedious process of finding which procedure wrecks your data.
The way to do this is start at the beginning and monitor the data after every transaction.

Also make backup copies of the database as you go, so when you find the problem you can go back a short way in time and restore the data to it’s original form.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[meekon5]

Darn, I was trying to avoid the fact that its my process that is causing the problem. I was brought in to build a bridge between two processes for eight weeks, decided that Excel was not the platform an put everything onto access. Unfortunately ten months later I'm still here and have built a monster that sucks my every moment in maintaining it. Human error it is then. Still part of the problem of trying to run a system so complex on this software. Thanxs