Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2010 Records Mysteriously Deleted

Posted on 2013-01-16
5
Medium Priority
?
450 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
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: …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

877 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