I always wonder why this happened to my system.....a situation like this. I redesign my system since its predecessors made me a lot of headache. The previous months after it was been upgraded many complains in one particular problem. This is what the problem is......they notice that in no particular time there are data that are deleted automatically inside my database. There are times but not frequent it happens. I review my codes and all delete commands to my SQL are in ordered properly....I also put some codes to trap if someone intentionally do this but found out nothing. If this happened could it be related to my SQL Server database? I could not figure out whats the problem. If someone have an idea about this please post a reply. By the way I am using VB6 language and SQL server 7 for my database. Thanks everyone in advance and God Bless.