A 3rd party made Access database "stops working" once a command to generate a report is clicked on the UI

What is the overall process of trying to reverse engineer this database to make it so that if you insert a date "8/15/15" then it will pull from the table.  This program used to work and now every time you try to input any date it crashes saying that microsoft access has stopped working.
Jeremy GohmanNetwork EngineerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Jeffrey CoachmanMIS LiasonCommented:
What has changed since the last time this worked?

Try the usual:
Run the compact/repair utility
Then re-test
If the issue still persists ,...then create a new blank database an import all the objects, ....then retest.

Cant say much more unless we know more about this system,..or you post a simple sample db with an explanation.

JeffCoachman

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
PatHartmanCommented:
If this is a "packaged" product, you might be able to resolve the problem by reinstalling it.  Just make sure that you are not going to lose any data.  The app should be separated into FE/BE but make absolutely certain that the BE is backed up before attempting a reinstall.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Also be sure your Office and Windows installations are fully up to date. Often a botched/faulty install will cause issues like this.

Also, if by "3rd Party" you mean a commercial program, then you might consider contacting the manufacturer of the software. They may have a very simple fix for you.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jeremy GohmanNetwork EngineerAuthor Commented:
Compact repair doesn't work.  What are the odds that this database is too large.  There are several tables containing 60000 plus records.  I'm wondering if this dataset is too large or if there is bad data that is causing this... Pat this is considered an unpackaged item
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Hard to say about being too big, but you can view the size by locating the db on disc. 2gb is the max size since Access 2000. "several tables containing 60000 plus records" is really not that large, but of course your reporting application could be choking on that number. Hard to say without knowing more about it.
Jeremy GohmanNetwork EngineerAuthor Commented:
Sorry for the misunderstanding and broad question. A new database was sent over from the 3rd party and is working now.
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
DB Reporting Tools

From novice to tech pro — start learning today.