Solved

Jet vs ACE

Posted on 2016-07-15
7
48 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 84
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 84

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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 7

Author Closing Comment

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

 Not that I'm aware.

Jim.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

856 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