<div>
The version of Access where the FE is run would determine that, so it would be the ACE engine. The BE of a split architecture is little more than a text file (assuming an Access BE, of course).<br />
<br />
At least that's my assumption.
</div>


<div>
Thanks Scott<br />
would you know if the format of the 2000 BE is the same as a 2010 BE (if the 2000 one was was updated), and if updating the BE would increase performance? (i.e. does the ACE work better on a newer BE?
</div>


<div>
um...couple of points.<br />
<br />
ACE and JET 4.0 are virtually the same. &nbsp;Outside of a few new data types and a different team taking it over, that's it.<br />
<br />
As far as your question:<br />
<br />
&lt;&lt;assuming a 2000 BE and a 2010 FE, which engine is in effect? &gt;&gt;<br />
<br />
It's more appropriate to ask what code base is in effect, and that would be the version of MSACCESS.EXE that is running.<br />
<br />
That code base supports both JET 4.0 and ACE versions. &nbsp; When the DB is opened, the format is determined and the version, and any version specific rules for that version are followed.<br />
<br />
&nbsp;They are both though fundamentally the same. &nbsp;JET 3.5 and back were different, but 4.0 and ACE are not.<br />
<br />
Jim.
</div>


<div>
Didn't Microsoft drop the ACE acronym (not 'ace' itself) ? &nbsp;Access Connectivity Engine ?
</div>


<div>
&lt;&lt;Didn't Microsoft drop the ACE acronym (not 'ace' itself) ? &gt;&gt;<br />
<br />
&nbsp;Not that I'm aware.<br />
<br />
Jim.
</div>


<div>
<div class="content wysiwyg-content">
Hi Folks,<br />
assuming a 2000 BE and a 2010 FE, which engine is in effect? (the BE or the FE?)<br />
thank you
</div>
</div>


Hi Folks,
assuming a 2000 BE and a 2010 FE, which engine is in effect? (the BE or the FE?)
thank you

Jet vs ACE

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.