Losing data

[esskay]

We have an application which we have developed running at dozens of locations. We heard reports about a number of records missing from one of our critical tables. We have verified that the data is missing. We have no deletes for this table in our code, so I don't understand how this might be happening. Any ideas?

These applications are running MSDE SP2 on Windows XP Professional.

Also, I see numerous "Starting Up Database " in the logs, sometimes within minutes of each other. The system has not been restarted, so I can't figure out what is causing it/ Is that normal?

 

[ecobb]

I'm not sure about the missing data, but as far as the "starting up database" goes, right click on the database and go to properties, then look under the "options" tab and make sure Recovery is set to "Full".

Hope this helps!

 

[Databaseguy]

I had the same problem. Upon further investigation,I did find an SP or two that would delete records. My fix was locking down the Access front end completely (hiding the DB view, dis-allowing special keys, creating custom menus and tool bars, and running code to dis aloow bypass on startup).

I also purchased Lumigents log analyzer, which tells me when, who, and what records were deleted and has an option to roll back the delete.

 

[SonOfEmidec1100]

Also on the options tab if Auto close is checked the database will be 'shut down after its resources are freed and all users exit' then when a user connects the starting up database msg is generated. I would uncheck it.

 

[MaffewW]

maybe you could set up a trigger on this table as well so say when a record is deleted from your critical table you insert some info about it into an audit table like a time stamp and userid to help you find who is deleting these records

Matt

Brighton, UK