Detecting Access version from VBA

[Linus_99]

Hi,

I'm building an application that needs to run on Access 2002 and Access 2000, and I need to detect from VBA which version is running.

I used strVer=Application.Version in 2002 and it works fine (returns 10.0).

However, this does not appear work in 2000.

Application.Currentdb.Version and Application.Dbengine.Version give me the same versions for 2002 and 2000 so they can't be used to sense the difference.

Can anyone suggest a way that runs in both 2002 and 2000, and returns different version numbers ?

Any help would be appreciated.
Linus

 

[smozgur]

Hi, Linus

Try this:

SysCmd(acSysCmdAccessVer)

It would help.
Suat

 

[Linus_99]

Thanks a lot Suat,

That works exactly as I require.

Cheers,
Linus

 

[smozgur]

You're welcome, Linus.

Suat