Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Jet vs ACE

Posted on 2016-07-15
7
Medium Priority
?
120 Views
Last Modified: 2016-07-16
Hi Folks,
assuming a 2000 BE and a 2010 FE, which engine is in effect? (the BE or the FE?)
thank you
0
Comment
Question by:COACHMAN99
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 85
ID: 41713505
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
 
LVL 7

Author Comment

by:COACHMAN99
ID: 41713518
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
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 41713542
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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 7

Author Closing Comment

by:COACHMAN99
ID: 41713646
cheers.
0
 
LVL 58
ID: 41714539
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
 
LVL 75
ID: 41714676
Didn't Microsoft drop the ACE acronym (not 'ace' itself) ?  Access Connectivity Engine ?
0
 
LVL 58
ID: 41714769
<<Didn't Microsoft drop the ACE acronym (not 'ace' itself) ? >>

 Not that I'm aware.

Jim.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question