Solved

Jet vs ACE

Posted on 2016-07-15
7
74 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 500 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

626 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