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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paul Cook-GilesSenior Application DeveloperCommented:
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?
frimyAuthor Commented:
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-GilesSenior Application DeveloperCommented:
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?
Price Your IT Services for Profit

Managed service contracts are great - when they're making you money. Yes, you’re getting paid monthly, but is it actually profitable? Learn to calculate your hourly overhead burden so you can master your IT services pricing strategy.

frimyAuthor Commented:
my users don't have access to the tables only with forms with Header and sub form for the Detail.
Paul Cook-GilesSenior Application DeveloperCommented:
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 BernsteinChief Developer/ Microsoft AccessCommented:
Database corruption is always a possibility.
Sean SmithSQL DBACommented:
I agree with David, there might be database corruption. Try to run Compact and repair.
Paul Cook-GilesSenior Application DeveloperCommented:
frimy, where are you with the resolution of this problem?
frimyAuthor Commented:
So far I didn't found any solution.
but I think the problem was,
The customer just told me that many times he is opening the Invoice Details from my Continuous Form and then he right clicks to see in data sheet view for more options.
On the form I locked the controls but I wasn't thinking about the DS view.
I'm almost sure since he was playing around with the data, he was probably deleting some records and didn't realize it has an effect on the data.
He thought it's like Excel view (because I have an option to export the data to Excel.
Thanks you all

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.