Database losing records

[Mark Dudley]

Hi,

We have a fairly large Access 2000 database which has been behaving itself perfectly for ages. Suddenly since Christmas records have started apparently deleting themselves in front of our eyes. The database is on a 2003 Server and all the machines in the domain are XP professional. The records are in a subform on a form and seem randomly to disappear, to be replaced with the word #Deleted# in all fields. I have a copy of the database on a stanalaone machine and cannot duplicate the problem. Has anyone any idea what might be causing this. We have run anti-virus and anti spy-ware checks on all machines.

Mark Dudley

 

[PARSO]

are the records deleting from the actual table? or are they still there if you open the table?

 

[Mark Dudley]

Deleted Records

They are deleted from the table. It seems to be limited to three tables, two of which are in a relationship with the third through a common field 'CODE' which is the main index of the third table.

 

[eleanor b]

solution?

Dear Mark

I was just wondering if you ever found a solution to this problem, as my databse is also deleting records from one table for absolutely no reason - it has been fine for the 18 months I have worked on it. I cannot work out why and can't get it to stop. I would be grateful to know if you ever solved the problem with yours.

thanks, Eleanor

 

[IgorB]

Try to see your queries.
I've got sometimes in a query result also #Deleted# presentation(could be complex query with right/left joints or join table on itself) but actual data is still in the table.

Igor.

 

[directormac]

Also, check the relationships to see if "cascade delete" is checked.

--Cascading Mac

 

[The_Doc_Man]

Offhand, the first place I would look is to see if there is some common table sharing relationships with the tables losing data, for which relational integrity has been asserted. If you have data deletions from the common table, any tables on the wrong end of the relationship will have deletions automagically.

 

[Pat Hartman]

Are there memo fields in the table with the problem? This sounds like that bug.