We help IT Professionals succeed at work.

Missing Records

frimy
frimy asked
on
91 Views
Last Modified: 2018-12-10
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
Comment
Watch Question

Paul Cook-GilesSenior Application Developer
CERTIFIED EXPERT

Commented:
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?

Author

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 Developer
CERTIFIED EXPERT

Commented:
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?

Author

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 Developer
CERTIFIED EXPERT

Commented:
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 Access
CERTIFIED EXPERT

Commented:
Database corruption is always a possibility.
Sean SmithSQL DBA

Commented:
I agree with David, there might be database corruption. Try to run Compact and repair.
Paul Cook-GilesSenior Application Developer
CERTIFIED EXPERT

Commented:
frimy, where are you with the resolution of this problem?
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.