Solved

Access 2010 Records Mysteriously Deleted

Posted on 2013-01-16
5
439 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article will show you how to use shortcut menus in the Access run-time environment.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
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…

776 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