
Reading Access Revision Info at signon
I am running a front-end database in a multi-user
environment where several users share the file (I know,
bad idea). We have found that if all the users are not
running the same version of Access with the same Service
Pack that the file becomes corrupted. I built a table and
log each user as they open the file. I am able to use
the "SysCmd(acSysCmdAccessVer)" to grab the version of
Access they are using and plug it into my table. I would
also like to check the service pack and store that info so
I can see who the culprit is that needs to upgrade to SR-
2. Does anyone know how to store this information?
Thanks in advance for your help!
Rick Bear - KeyTrak
.