I have an application in production that

has 20 or so tables; 12 or so forms bound to

a combination of those tables. (Is running on a network)

1 table seems to every so often (twice since inception in Sept)

lose items. Most users are blocked out of "deleting" and

not much deletion takes place anyway.

This table is used mostly as a code table and the orginal

layout (dev. in AREV) kept item ids in a field in the master

table. (i.e. XREF 203]210]415)

I am guessing that some how, because it is a series of connected

codes that seem to go missing, that something reads these keys and

then deletes the items.

But, I am stumped as to where or how. I have alot of my own scripts

but none actually delete anything.

I have wondered though if it is possible that in a form that may at one time had a edittable control that had "Database selection criteria"

in it may be causing a problem. How could I check this??

Also, in the mean time of trying to debug I want to restore the

table from a backup. What are the ramifications of finding out the

dos filename (ROSxxxxx.o and l) and renaming and then restoring

those same names from a backup?

Any info or related situations would be helpful. Thanks

BC,

I assume you have checked for GFEs? I've heard about a GFE that only showed itself in that some rows disappeared.

- Oystein -

O,

I will double check but things there seem ok.

B

Bruce,

We had "unexplained" deletions happening so we developed an audit trail for our tables. We were able to trace the problem back to user error. It really should be an MFS for absolute tracking but you can get away with it by placing a hook into every process that can update your records. Then check your audit trail to see which acivity is removing the items.

[email protected]

SRP Computer Solutions

Don,

Thanks, can you give me some more info on MFS auditing or

point in a direction to find out more?

Bruce

View this thread on the forum...