?
Solved

Access 2010 Records Mysteriously Deleted

Posted on 2013-01-16
5
Medium Priority
?
446 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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