A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

My database is deleting rows by itself??



 
 
Thread Tools Display Modes
  #1  
Old October 16th, 2009, 04:14 PM posted to microsoft.public.access.tablesdbdesign
Adele
external usenet poster
 
Posts: 13
Default 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  
Old October 16th, 2009, 04:28 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default 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  
Old October 19th, 2009, 04:27 PM posted to microsoft.public.access.tablesdbdesign
Dorian
external usenet poster
 
Posts: 542
Default 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  
Old October 20th, 2009, 01:53 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.