API call AllocConsole no longer works in Access 2016 on Windows 10

New Contributor

The windows API call AllocConsole no longer seems to work in VBA Access 2016 on Windows 10.


It functions correctly on Windows 7 with Access 2016 and I've been googling for the past few days tring to find an answer. The code is a follows...


Private Declare Function AllocConsole Lib "kernel32" () As Long


Function main_loop()




         'do other stuff

   Loop While True

End Function


AllocConsole always return 0 on windows 10.


Running Access as an Administrator and enabing macros and adding trust centre setting etc have no effect.


Is there a work around to get a console window to open?







3 Replies

I have a similar problem in my C# windows app where I allocate a console window. The console window shows, but the output stream and tracing no longer works on windows 10.


Have you found a solution to your problem?

This may be a long shot, but have you verified that this API is actually available on the Windows 10 computer? 

best response confirmed by George Hepworth (Super Contributor)

I found a work around by using Access 2013 on Windows 10. The AllocConsole function then works!