Solved

Access 2010 Records Mysteriously Deleted

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

726 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