If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
My database is deleting rows by itself??
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 |
#2
|
|||
|
|||
My database is deleting rows by itself??
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. "Adele" wrote in message ... 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 |
#3
|
|||
|
|||
My database is deleting rows by itself??
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". "Adele" wrote: 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 |
#4
|
|||
|
|||
My database is deleting rows by itself??
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. |
Thread Tools | |
Display Modes | |
|
|