Solved

Access 2010 Records Mysteriously Deleted

Posted on 2013-01-16
5
433 Views
Last Modified: 2013-02-03
Experts. I have a .mdb database running in 2010 with two main tables tblProperty and tblGetPropInfo. tblGetPropInfo is linked all over this database and linked in other databases. The database is about 5 years old and I've never had this issue.

In the last week records are "mysteriously" gone from tblGetPropInfo. I've had to restore it back to a previous day when all records are there. This is fine except if changes were made, those changes are lost.

I've checked to see if someone accidently saved over the "property name" field but the autonumber for the record isn't there any longer so the record is completly gone. I've also search through all the code in the database and there isn't any reference to delete * from tblGetPropInfo.

If anyone has any suggestions as to what's happening or how to fix this please let me know. I would really appreciate it.
0
Comment
Question by:acramer_dominium
  • 3
5 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 38785166
Its possible that the records got deleted directly, even if there is no 'Delete *' in your code.

Do you have any forms that are based on this table?  If so, check the setting of the Allow Deletions property.

Do your users have direct access to the tables - which would allow them to delete records without code or forms?

Have you had any issue with corruption recently?  Compact/repairing can completely remove corrupt records, ID and all.  (The records would have been lost/inaccessible anyhow)
0
 
LVL 77

Expert Comment

by:peter57r
ID: 38786405
"tblGetPropInfo is linked all over this database and linked in other databases"

So any of these other databases that use the table could have users that are deleting records?
0
 

Author Comment

by:acramer_dominium
ID: 38787442
There is a possibilty but like I said, we've had the system in place for so long and this has never been an issue. We haven't launched any new databases in the last month (since this has happened).
0
 

Accepted Solution

by:
acramer_dominium earned 0 total points
ID: 38831705
The solution seemed to be compacting and repairing the database. I did a compact and repair and nothing "disappeared" for a little over a week. Now today another property disappeared so tonight I will do another compact and repair. The database doesn't like something that's going on.

I'm going to use as my resolution until I stumble upon something else.

Thank you for the feedback!
0
 

Author Closing Comment

by:acramer_dominium
ID: 38848281
No other comments seemed to provide a solution or guidance. This was such a broad question it took testing a bunch of different possible solutions to determine the issue.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now