Jet vs ACE

Hi Folks,
assuming a 2000 BE and a 2010 FE, which engine is in effect? (the BE or the FE?)
thank you
LVL 7
COACHMAN99Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
If by "2000 BE" you mean a file formatted as a .mdb file, then no, it would not be the same as a file formatted as a "2010 BE", which would be an .accdb file.

I'm not sure you'd notice any performance gains by converting a backend to the .accdb format, but it certainly would not hurt. As long as your users are all running 2007+, you should be fine.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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).

At least that's my assumption.
0
 
COACHMAN99Author Commented:
Thanks Scott
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?
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
COACHMAN99Author Commented:
cheers.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
um...couple of points.

ACE and JET 4.0 are virtually the same.  Outside of a few new data types and a different team taking it over, that's it.

As far as your question:

<<assuming a 2000 BE and a 2010 FE, which engine is in effect? >>

It's more appropriate to ask what code base is in effect, and that would be the version of MSACCESS.EXE that is running.

That code base supports both JET 4.0 and ACE versions.   When the DB is opened, the format is determined and the version, and any version specific rules for that version are followed.

 They are both though fundamentally the same.  JET 3.5 and back were different, but 4.0 and ACE are not.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Didn't Microsoft drop the ACE acronym (not 'ace' itself) ?  Access Connectivity Engine ?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Didn't Microsoft drop the ACE acronym (not 'ace' itself) ? >>

 Not that I'm aware.

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

All Courses

From novice to tech pro — start learning today.