Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 653
  • Last Modified:

MDE or ACCDE

I am soon to release a MS Access application that will work equally well as an mde as it will an accde file. I will be using SageKey and releasing it with MS Access 2007 runtime version included to avoid issues with various configurations. Which is a better format, mde or accde?
0
Rob4077
Asked:
Rob4077
  • 3
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
Neither is "Better"

Use accde if you are 100% positive that all machines that need to access this db are running Office 2007.
But even if all users have Off 2007, a mde fill should work just as well.
The Kicker here is that .accde files will support the Access 2007 features, ..whereas .mde files cannot.

So if you are using Attachment Datatypes, Multivalued fields, ...etc, (Access 2007 features) using the MDE format is not an option.

;-)

JeffCoachman
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Just noting "and releasing it with MS Access 2007 runtime version "

mx
0
 
Jeffrey CoachmanCommented:
...oh

Joe, feel free to make any clarifications/corrections on my post above if the runtime makes a difference.
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!

 
Rob4077Author Commented:
Thanks for the confirmation. I thought I read somewhere that 2007 files were slower but it sounds like my memory is misleading me....again. Appreciate your help
0
 
Jeffrey CoachmanCommented:
"Files"... in and of themselves are not slower of faster.

accdb files are more "complex" because of the new features, and hence they may take longer to process.
But I have never heard of a accde file being "significantly" slower than an mde file...

The bottom line is that if you are using any the Access 2007 format, (.accdb) you will only be allowed to create .accde files...

;-)

JeffCoachman
0
 
Rob4077Author Commented:
Thanks Jeff.
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now