Break / Pause VBA command (1 Viewer)

[cheer]

If I Step Into (F8) codes, application won't produce any error in DB connection, but if I execute / run the entire application, it will produce error "ODBC--connection to 'erpServer' failed"

The only different I can think off is there is a break / pause during Step In activity regardless how long time you have stopped. Meanwhile, codes will continue to execute in real environment and resulting the above error.

If my analyst is true, can anyone suggest how to overcome this problem by having a "Break / Pause" in real execution via VBA command ?

fyi, I am using the MS Access 2016, 64 bits. Presently I am using connection string

Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=XXXXX

Alternatively is suggestion to correct my connection string

 

[Minty]

I would have a read here https://www.access-programmers.co.uk/forums/showthread.php?t=139084 for tips and ODBC background information.

 

[cheer]

I would have a read here https://www.access-programmers.co.uk/forums/showthread.php?t=139084 for tips and ODBC background information.

The content (connection string) is too old to execute the MS Access 2016

 

[Minty]

You may need to have a hidden form that keeps a persistent connection open, if you are getting drop outs.
This thread discusses the issue with a view to performance but the same may apply. https://www.access-programmers.co.uk/forums/showpost.php?p=1543821&postcount=1

 

[JHB]

..
If my analyst is true, can anyone suggest how to overcome this problem by having a "Break / Pause" in real execution via VBA command ?
..

You could try to add the command DoEvents in one or more places in your code.

 

[missinglinq]

When stepping thru code doesn't cause the error that appears when actually running the code, the problem is usually a timing problem, of one sort or another...and JHB's suggested may resolve the problem.

Linq ;0)>