MS Access – Determine if Runtime or Full Version

As you start to do more and more advanced vba development you may have the need to determine whether your user is using the full blown version of MS Access or the runtime version. Some code/procedures will throw errors in the runtime, that normally would not in the full blown version of MS Access. So how can you determine this? Well, it is surprisingly simple! A simple IF statement can determine this for you, as shown below.

    If SysCmd(acSysCmdRuntime) = False Then
        'The user is using a full blown version of MS Access
        
    Else
        'The user is using the runtime version of MS Access

    End If

4 responses on “MS Access – Determine if Runtime or Full Version”

  3. m

    Thank you. Now I can avoid runtime error 2544 while running code providing security to Access, which should be a staple of any database, but seems to be an afterthought with Microsoft.

  4. Nigel Smith

    Daniel, many thanks. You’re a star and have helped me a lot on a number of topics. Nigel-from England