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

Access compatibility check 2003 - 2007

Experts,

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
else
 code A2007
end if

Thx in advance
0
ITBenelux
Asked:
ITBenelux
  • 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>
Else
 <other>
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).
0
 
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.

Thx
0
 
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.
0
 
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
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

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