My database is deleting rows by itself??

[Adele]

I have a very small Database with 4 tables a few qrys and frms. This
database has been used for years with only one table. Recently I added three
tables to be able to keep some historical information.
Every couple of weeks there are several rows in the main table that get
deleted. Anything marked Vacant gets deleted! there are no action queries
in this database and I only have one crosstab query for one form. I cannot
find how these files are being deleted.
Please help??
Thank you

 

[Jeff Boyce]

Adele

There's deleted, and then there's "deleted".

If you can't see it, it's deleted, right? Nope! I can write a query that
excludes all rows marked "Vacant", so that I'm only seeing the non-Vacant
rows.

Any chance your query(ies) are excluding "Vacant"?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Dorian]

How many users of the database are there?
Did you check if there is any VB code that does deletions?
Go into design view on a form, access the code, and search the entire
project for the table name.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Fred]

So that test of that would be to think about the data in / specifics of a
record that you think has been "deleted", go directly to the table view,
choose records-Remove Filter / Sort, and then look for your "deleted" record
and see if it has really been deleted.