jdana
asked on
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for a GREAT synopsis of the MDB / ACCDB issue.
J