[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

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

Access MDB versus ACCDB - Pros and Cons of Switching Over

I've created 4 or 5 old Access databases that are still in an MDB file format (all with MSSQL backends) that my clients just keep using. Is it worth upgrading them to the ACCDB file format?

Most my clients are running Access 2010 with an occasional instance of of 2007 or 2013.
I'm not sure when Microsoft plans on discontinuing support of the MDB file format. Will Office V16 (Office 2013 being Office V15) no longer support the MDB file format, for example?
I'm also not sure about MDB versus ACCDB speeds. When connected to a solid MSSQL backend, both formats seem to run pretty quickly. I think I see slightly better performances out of ACCDB files, but there are so many variables that factor into the comparison, that I can't say for sure.
0
jdana
Asked:
jdana
3 Solutions
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<Most my clients are running Access 2010 with an occasional instance of of 2007 or 2013.>>

 Doesn't matter.  JET 4.0 is supported.

 If you don't need anything ACE offers (multi-value fields, attachement data type, etc) then there is no real reason to switch.

 Note that ACE does not support workgroup (ULS - User Level Security).

<<I'm not sure when Microsoft plans on discontinuing support of the MDB file format. Will Office V16 (Office 2013 being Office V15) no longer support the MDB file format, for example?>>

 They dropped support for MDB's in JET 3.5 and prior in A2013.  No word on the the 4.0 MDB format, but I would suspect it will be a couple of more releases at least.

<<I'm also not sure about MDB versus ACCDB speeds.>>

 There is none that I'm aware of; it's the same database engine with a couple of add-ons.  But fundamentally, they are one in the same.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
MDB is seven years past history :-)

Also, there are some nice new (relatively) features in the ACCDB format (cosmetic especially) not available in MDB format.

I'm in the process of converting ALL 40+ mdbs here at work to ACCDB format ... because it's ... 'time'.

BUT ... overall ... there is really no overwhelming compelling reason to switch per se :-)

mx
0
 
Luke ChungPresidentCommented:
If your Access MDB file is in the Access 97 format, you'll want to upgrade it to the later Access 2003 format.

ACCDB's don't support workgroup security but have more sophisticated encryption if there's a concern of unauthorized people walking away with data on a thumb drive.
0
 
jdanaAuthor Commented:
Jim,

Thanks for a GREAT synopsis of the MDB / ACCDB issue.

J
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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