Avatar of frimy
Flag 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
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon
Paul Cook-Giles

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?

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.
Paul Cook-Giles

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?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck

my users don't have access to the tables only with forms with Header and sub form for the Detail.
Paul Cook-Giles

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.  :)
David Bernstein

Database corruption is always a possibility.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Sean Smith

I agree with David, there might be database corruption. Try to run Compact and repair.
Paul Cook-Giles

frimy, where are you with the resolution of this problem?

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question