Link to home
Start Free TrialLog in
Avatar of frimy
frimyFlag for United States of America

asked on

Missing Records

Hello All,

I up-sized a 2010 mdb Front-End to 2016 Accde but the Back-end is still mdb format.
it was working fine for four weeks.
Now my customer calls me that they are loosing Detail records from the Invoice table.
i checked and checked for any possibilities that we might be changing that can cause to delete records.
But i don't see anything, i also checked the Advanced Options it's the same as the 2010, Record level-locking etc.
Does anybody have an idea what it could be because it's a big problem?
Thanks in advance
Avatar of Paul Cook-Giles
Paul Cook-Giles
Flag of United States of America image

Are they seeing gaps in the records when they look at query results?  Or when they look directly at the data in table view?
Did the now-missing records exist prior to the front end conversion?  Or are they records that were created after the conversion?
Avatar of frimy

ASKER

1)  in the table view I see missing ID's (auto numbers), in a invoice with ten Detail recs can be missing like four recs (not consecutive)
2)  the recs are before the conversation, there were there two weeks ago.
Well, that blows the theory that a query was somehow not picking up records that it should have grabbed.  :(

If you have a pre-conversion backup of the data, you should be able to restore the missing records (by running an append query that selects IDs from the backup table that are not in (select IDs from the current table) ;  if not, you're probably hosed.  


A few more thoughts:
Don't let your users see the table view;  lock the db so that they can't get at the data directly;  require that they use forms and buttons to manipulate the data.
Consider setting the forms that display the records (invoices and details both) to not allow deletions.  If a record needs to be excluded from future consideration, give it ObsoleteDt and ObsoleteBy field, create a button that populates both those fields, and then set your forms, queries, and reports criteria to exclude any record with a populated ObsoleteDt.

Anyone else have suggestions or useful thoughts?
Avatar of frimy

ASKER

my users don't have access to the tables only with forms with Header and sub form for the Detail.
That's good.  I definitely recommend setting the subform to not allow deletion of records, and creating a button to exclude (which will look to the user like deleting) records.  :)
Database corruption is always a possibility.
Avatar of Sean Smith
Sean Smith

I agree with David, there might be database corruption. Try to run Compact and repair.
frimy, where are you with the resolution of this problem?
ASKER CERTIFIED SOLUTION
Avatar of frimy
frimy
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial