To get access to the game console, you need to start maxpayne.exe with the command line parameter "-developer". Once you have the game running in developer mode, you get access to the game console with [F12].