No, it looks like Microsoft has disabled security for the application in favor of security for the user. http://office.microsoft.com/en-us/ac...010341741.aspx
Before the database is trusted by the user, the Access application won't allow the user to alter the database in any way. That seems to preclude storing any information about the attempted logon.
POTENTIAL WORKAROUNDS
Can you tell me more about what you're trying to find out before the user logs in? You may be able to achieve the desired results by, for instance, launching the application using a script with indirection, rather than by directly launching the database file or Access application.
UPDATE - THE FOLLOWING WON'T WORK FOR YOUR ISSUE -
Perhaps you could follow different paths for the two types, based upon the value of this -
Code:
Dim varRet As Variant
varRet = SysCmd(acSysCmdAccessVer)
Debug.Print " * "
Debug.Print " * *** ACQUIRING ACCESS VERSION *** * "
Debug.Print " * "
Debug.Print " * Your MS Access Version Is " & Application.Version
Debug.Print " * Your MS Access Syscmd Version Is " & varRet
Debug.Print " * V11.0 is 2003, V12.0 is 2007, V14.0 is 2010"
sample results:
Code:
* *** ACQUIRING ACCESS VERSION *** *
*
* Your MS Access Version Is 14.0
* Your MS Access Syscmd Version Is 14.0
* V11.0 is 2003, V12.0 is 2007, V14.0 is 2010
*
(like I said, doesn't work for your need, since no VBA will run before that ENABLE CONTENT banner is clicked.)