• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

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
1 Solution
Sometimes when you close DB with breakpoint, it is saved, but "hidden". I think it is bug in Access. You can Open DB, set breakpoint to this line, run code, remove breakpoint from this line, continue execution, close DB. Next time it will work without stops.
Jeffrey CoachmanMIS LiasonCommented:
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?

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
You can reboot and that should fix it ... I've yet to see a case where it  did not.

Jeffrey CoachmanMIS LiasonCommented:
Obviously try MX's post first...
sharpapproachAuthor Commented:
Fixed it! Thanks!  Must have been hidden
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now