473,327 Members | 2,074 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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 2303
-----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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBRAYKU4echKqOuFEgEQLZfACdHTFWwPehNKltGfarSIqtxS IWx5EAoLh6
lR2AmB/5y3i1JOpo5w7WH0gP
=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
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...
28
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...
10
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...
5
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
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...
1
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...
3
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...
6
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...
11
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)...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.