• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Access compatibility check 2003 - 2007


I'm want to starrt using my A2003 (ADP) application in a 2007 environment, but there is some code that I need to re-write for 2007.  as it is only a few lines, I want to add and if then else structure to determine the access version ?  any idea how I can do this ?
something like
If straccess_version = "2003" then
 code A2003
 code A2007
end if

Thx in advance
  • 2
  • 2
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Application.Version will provide you the current version of Access ... for example, Access 2003 is "11.0", so you can do this:

If Application.Version="11.0" Then
 <2003 code here>
End If

Although I have to ask: What code are you running in 2003 that must be different in 2007? You would be FAAAR better off not having version specific code (and almost every version of Access is backwards compatible, so code written for 2003 should work in 2007 with no modifications).
ITBeneluxAuthor Commented:
That was the line, I was looking for.  To answer your question, some adp's will have to run in a mixed environment for a while, that what I needed the check for.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I see ... but what code are you running in 2003 that will NOT run in 2007? Any code that is viable on the 03 platform should work on the 07 platform, assuming you're not converting to the ACCDB format ... and even then, most code would work.
ITBeneluxAuthor Commented:
It is mainly a Ribbon issue.  my custom toolbar's shows up in the add-in toolbar.  So I just skip some code in 2007
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now