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.
jdanaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.