asked on 5/21/2013

Access VB stops

We have an Access Database that has been in Production for years.

All of a sudden this has started happening:

When you first open the database and run a Verify button that has code, it puts the users into the VB window with the line highlighted. However, there are no break points or stop statements.

The user hits the Run button on VB, and it will run. It never happens again that day day.

It happens to every user.

Why is it doing this??? It is very annoying for our users.

Thanks for any guidance

Microsoft Access

Last Comment

sharpapproach

5/21/2013

ASKER CERTIFIED SOLUTION

als315

5/21/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Jeffrey Coachman

5/21/2013

Without a sample of the code, this is difficult to troubleshoot...
Can you post the code, and a screenshot of the VB error?

The usual things to try:
Run the compact and Repair utility
Create a new database and import all the objects
Decompile the database (http://www.fmsinc.com/microsoftaccess/performance/decompile.asp)
Make sure all the Updates and service packs are installed for Office and windows...

<All of a sudden this has started happening:>
Meaning absolutely nothing changed? (new OS, New office version, ...ect)

Is this for all users?
Is this for all databases?

JeffCoachman

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

5/21/2013

You can reboot and that should fix it ... I've yet to see a case where it did not.

mx

Jeffrey Coachman

5/21/2013

Obviously try MX's post first...

sharpapproach

5/21/2013

ASKER

Fixed it! Thanks! Must have been hidden