473,881 Members | 1,572 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Records Getting Deleted from Key Table

I have a database with a split front end/back end. There is a key
table in the back end called Catalog, and it is sort of a central key
table for all sorts of things. It's a list of all the jobs that have
ever been worked on at our company. Records are getting lost out of
this table, but I have no way of figuring out how they're being
deleted. Records should NEVER be deleted out of this table. They can
be marked as inactive, or something like that, but nowhere, in any code
do I ever display this table for the users, and allow them edit access,
and nowhere in the VB code I have written do I ever delete records out
of that table.

One hint, I don't know if this means anything, but the records always
seem to dissapear off the TOP of the table. It's always the first
record in the table that gets deleted. We put 20 dummy lines at the
top of the table just to keep real jobs from dissapearing. This works
pretty well. I also have written a routine that makes a copy of the
catalog table, and then the next time you go into the table, it
compares the current table with the snapshot that was made, and if it
finds records in the older snapshot that aren't in the current table,
then it re-appends these records in.

This whole thing is a little too flaky for my liking. I'm unaware of
any sort of tracking that Access has for this type of thing, like SQL
has some sort of mechanism that you could figure out who was deleting,
or what program, or workstation, or at least some clue as to what was
happening. I am without a paddle in this situation. It's an important
table, and my fixes of having dummy records, and the "did any records
dissapear?" routine, while they do seem to be working, I'd much rather
dig down and find out what is happening here.

Any suggestings would be helpful!

-BrianDP

Mar 1 '06 #1
3 2330
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sounds like a corrupted table. Run Compact & repair on the back end.
And/or create an new, blank DB file and import the tables from the old
Db. Or, recreate the tables in the new DB & link the old tables to the
new DB. Then use append queries to get the data from the old tables
into the new tables.

If you want to be sure no one is slipping in and deleting records set up
User Security and RWOP queries. Deny access to the tables and access
the data thru the RWOP queries (do not allow Delete permissions on the
table to any user but the Administrator). Read the Access Security FAQ
for details (on the MS site).
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRAYKU4echKq OuFEgEQLZfACdHT FWwPehNKltGfarS IqtxSIWx5EAoLh6
lR2AmB/5y3i1JOpo5w7WH0 gP
=aU2k
-----END PGP SIGNATURE-----

BrianDP wrote:
I have a database with a split front end/back end. There is a key
table in the back end called Catalog, and it is sort of a central key
table for all sorts of things. It's a list of all the jobs that have
ever been worked on at our company. Records are getting lost out of
this table, but I have no way of figuring out how they're being
deleted. Records should NEVER be deleted out of this table. They can
be marked as inactive, or something like that, but nowhere, in any code
do I ever display this table for the users, and allow them edit access,
and nowhere in the VB code I have written do I ever delete records out
of that table.

One hint, I don't know if this means anything, but the records always
seem to dissapear off the TOP of the table. It's always the first
record in the table that gets deleted. We put 20 dummy lines at the
top of the table just to keep real jobs from dissapearing. This works
pretty well. I also have written a routine that makes a copy of the
catalog table, and then the next time you go into the table, it
compares the current table with the snapshot that was made, and if it
finds records in the older snapshot that aren't in the current table,
then it re-appends these records in.

This whole thing is a little too flaky for my liking. I'm unaware of
any sort of tracking that Access has for this type of thing, like SQL
has some sort of mechanism that you could figure out who was deleting,
or what program, or workstation, or at least some clue as to what was
happening. I am without a paddle in this situation. It's an important
table, and my fixes of having dummy records, and the "did any records
dissapear?" routine, while they do seem to be working, I'd much rather
dig down and find out what is happening here.

Any suggestings would be helpful!

-BrianDP

Mar 1 '06 #2
Hello.

Just a point of reference. Is there any records that are being
deleted in any other table. If so, maybe you can check in the
relationship window and see if a link has been created between
that table and the main table of reference. If so, then check
and see if the "Cascade Delete Related Records" has been
selected. If so, deselect it.

Just my two cents worth.

Regards

Mar 2 '06 #3
No, no other records that I can tell, are being deleted from any other
tables.

There is one program that is run every morning, where they enter labor
transactions, and as it does, it opens this catalog table, and verifies
that the transaction they are entering actually has a job that exists
in the catalog table.

That program appears to be the culprit, because it's only in the early
morning when they're running that application this happens. The woman
who runs the program is some sort of speed demon as well, and gets 5
fields ahead of the entry program, so if something happens, and the
program breaks in the middle of her entry, we can't see where it broke.
I think it's that program, and I think something is happening that she
types SO fast that she doesn't see if she makes a little mistake, the
program breaks, and somehow she over-writes that record. I can't see
it any other way.

I suppose a solution would be for them to match the jobs against a copy
of the master table, that way if the records got deleted, they would
only be from a copy of the real table, not from the real thing.

-Brian

Mar 3 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2615
by: C Kirby | last post by:
I'm running a DB using MSDE (2000) that is interfaced by 2 different ades running on PCs with Access 2000 Runtime. One of the ADEs is a package accounting system that is very solid and stable, the other is a custom application that I wrote (much less solid and stable). The custom app only deals with a select few tables in the database, and the table in question is not one of those. With alarming regularity(daily), records are getting...
28
4078
by: Lee Rouse | last post by:
Hello all, This is going to be a rather lengthy "question". I have an Access 2k database, separated front end/back end. Front end copies are on about 30 workstations and used frequently during the work day. The backend has a table called CLIENTS with approximately 6000 client records. Changes to data in the table are made via a frontend db Form which has CLIENTS as its record source.
10
2820
by: DaveDiego | last post by:
I've had a user delete one of the client records, I do have a version of the DB with all records intact before the deletion occured. Whats the best approach to getting all the related records in each of the tables? I have about 12 tables to put data back into and multiple records for each. Would I need to make an append or update query for each table?
5
29022
by: Grant | last post by:
Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis
1
1989
by: KC | last post by:
I am using Access 2002, with a database template from MS Office. The Orders Management Database. I have tweaked this for use with our company. It is a small database with close to a 1000 records in our Orders table. Within this table are 80 records that I decided to delete to clean it up a bit. When I went into my data entry form, I noticed the bottom portion of the form was blank, this is usually the area that contains each customers...
1
3639
by: Ardith via AccessMonster.com | last post by:
Hi, I am running Access 2000. I have an application with a web-based front end which accesses an Access back end using ASP (not .Net). It is being used by two groups of people - identical web pages and database structure, just different data in the two databases. In one of them, the first four records disappeared at one point. In the other, one record (the same record) occasionally disappears.
3
8094
by: wvmbark | last post by:
First time poster... I just found this forum and it appears there's plenty of people here that could make short work of problem that's been driving me absolutely bonkers for months. Every day we incur numerous service problems “Events”. Each morning we have a global conference call where events which occurred within the previous 24 hours are discussed. Prior to the call, an analyst has to review these events and provide a report, ‘The Morning...
6
11299
by: satish mullapudi | last post by:
Hi All, I am getting strange situation. These r the steps I have followed: 1. Created an EMPLOYEE table with around 14 fields & 688038 records. (so a large table indeed). 2. Tried to delete all the rows in the table using the traditional DELETE FROM EMPLOYEE stmt. It is taking around 53 secs to delete all the records. So I have done the below steps to make it fatster: (i) Create an empty file called No_Data.DEL in the C:\ drive....
11
3694
by: shriil | last post by:
Hi I have this database that calculates and stores the incentive amount earned by employees of a particular department. Each record is entered by entering the Date, Shift (morn, eve, or night) and the 'employee name'. There is another table which assigns an ID to the Shifts, i.e. 1,2 and 3 for morn, eve & night shifts respectively. From the mother table, the incentive is calculated datewise for each employee as per his shift duty. In...
0
9776
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10400
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9552
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7108
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5780
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5976
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4597
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4194
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3223
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.