Determine version of Access in VBA?

[utzja1]

Greetings,

I developed a database in Access 2010 with a feature to export a report via e-mail where the report is converted to a PDF. I've since learned that a large number of users where the database will be in service have Access 2003 on their machines, which doesn't appear to support the PDF function.

Is it possible in VBA to check the version of Access that the user used to open the database? I'm considering an IF-THEN statement that exports the file in rich-text if the user version is 2003 but defaults to PDF for everything else. Any experts out there that have tried this?

Many thanks!

 

[pr2-eugin]

Application.Version should be able to tell you this. More on Version : http://en.wikipedia.org/wiki/Microsoft_Access#Versions

 

[utzja1]

Thanks. I don't think my question was phrased correctly, but your information is good. I found some code in the Microsoft library about version & build, and this is what popped out of a message box statement:

"You are currently running Microsoft Access, version 14.0, build 7104."

From your link, it looks like Version 11.0 is Access 2003, so I can build my logic around that. Problem solved!

Many thanks.

 

[CJ_London]

You might want to look at this link for creating pdfs from 2003

http://www.lebans.com/reporttopdf.htm

Or use Snapshot rather than rich text

 

[pr2-eugin]

Try this in the immediate window (Ctrl + G if you do not have it in the VBA window)!

MsgBox "You are currently running " & Application.Name & ", Version " &  Application.Version & ", Build " & Application.Build

Glad to help !

 

[utzja1]

Thanks, I've gotten the Lebans link from other forum members but my IT protocols at work are preventing me from downloading and playing with it. Rich-text will be acceptable for most people; all the users who are most likely to swap reports by e-mail will have Access 2007 or later.

Thanks!