<div>
That was the line, I was looking for. &nbsp;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.<br />
<br />
Thx
</div>


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

<div>
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.
</div>


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.

<div>
It is mainly a Ribbon issue. &nbsp;my custom toolbar's shows up in the add-in toolbar. &nbsp;So I just skip some code in 2007
</div>


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

<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
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. &nbsp;as it is only a few lines, I want to add and if then else structure to determine the access version ? &nbsp;any idea how I can do this ?<br />
something like<br />
If straccess_version = &quot;2003&quot; then<br />
&nbsp;code A2003<br />
else<br />
&nbsp;code A2007<br />
end if<br />
<br />
Thx in advance<br />

</div>
</div>


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


Access compatibility check 2003 - 2007

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.