#HOW TO MAKE AN AUTOEXEC IGNORE A LINE 64 BIT#

but need to debug the VBA startup code and initial form load in the VBA debugger. I have been finding and fixing things like bad configuration file entries, incorrect installation path, etc.

It fails multiple ways when only 32 bit MS Access 365/2019 is installed on the machine.The application runs OK on a machine with MS Access version before 2016.I had to add an empty 'Form_Open()' event handler for the form Added a 'Stop' as the first line of the macro named 'autoexec' and also as the first line of the startup form's 'Form_Open()' method.Run a macro which does not exist on MSAccess.exe command line, hit escape multiple times on the error messages, the click on the MSAccess ribbon to get to the VBA code.

If Navigation Pane opens I could edit the AutoExec macro or the startup form's Form_Open code

Hitting F11 to open the Navigation Pane in Access (does not open).

Holding down shift key when you open the MSAccess database.

The most difficult part is that many of the web pages and nearly all Microsoft pages related to this have been deleted from the web.

#HOW TO MAKE AN AUTOEXEC IGNORE A LINE 64 BIT#

Technical, MS Access 64 bit will treat some 32 bit data sent in/returned from the Win32 API as 64 bit causing errors. This app calls a few (5) Win32 API calls. Note that there are compatibility and VBA compiler errors if you run on a 64 bit MSAccess.exe if the VBA calls Windows operating system Win32 API methods.I'm using MSAccess.exe 32 bit from Office 365.I run a dos command for the database - PATH_TO_MSACCESS.exe DB_NAME.mdb.No MSAccess other files wuch as mdw security files.No MSAccess files in MDE or ACCDE formats with compiled VBA code.Multiple MSAccess files in MDB and ACCDB format.This is a mission critical system kept alive and on crutches for 15 years without any VBA code updates. It is an upgrade from Access 2003 to Access 2016, 2019 or 365. How do I bypass the MSAccess autoexec macro and startup form for a deep-legacy code upgrade of a large MS Access 2003 application with hundreds of forms and reports?

How to make an autoexec ignore a line