different versions of access if statement?

[Weresmytriple]

hi is there an if statement for when you are running two different versions of access.

for example

if i am running access 2003 then

run this code
else

run this code

thanks

michael

 

[pr2-eugin]

You need to check the Version of Access. http://en.wikipedia.org/wiki/Microsoft_Access#Versions

If CurrentDB.Version = 11.0 Then
[COLOR=Green]    'Run 2003 code[/COLOR]
Else
[COLOR=Green]    'Other code[/COLOR]
End If