Can I continue to use an older Access MDB format file with newer versions of Access ?

Chief Avocado
Chief Avocado used Ask the Experts™
on
Client has a database that works with Access 2010, but is in the older MBD format.   If he upgrades to Access 365/Access2016 will he be able to continue to use his older MDB format file or must he convert to the newer ACCDB format ?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
They can work with it, but it must be in Jet 4.0 format.  Note however that you will not be able to create a .MDE with it.

Jim.
John TsioumprisSoftware & Systems Engineer

Commented:
If is not that complex as an application probably it would better to convert it to .accdb...usually a simple import would be sufficient
Distinguished Expert 2017

Commented:
The  support for A97 was dropped a couple of years ago, can A2000 be far behind?  Convert to at least A2003 for best results for at least another year or two.

Why are you avoiding converting to .accdb format?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Hamed NasrRetired IT Professional

Commented:
You mean mdb format?
Yes!
But you loose upgraded functionality of Access 365.
You need to consider upgrading to the new format.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
<<But you loose upgraded functionality of Access 365.>>

 There's not much there to gain; attachment data type and Bigint support, which was recent and only in O365 version is about it.

Jim.
Chief AvocadoChief of Problem Avocado's

Author

Commented:
Why are you avoiding converting to .accdb format?

Coz the client is operating on a shoe-string budget and I'm not getting into that can of worms for free :-)
Chief AvocadoChief of Problem Avocado's

Author

Commented:
They can work with it, but it must be in Jet 4.0 format.
How can I check the Jet version ?
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
From the debug window:

?  CurrentDB.Version

 Will come back 4.0 or 3.x depending on what format it's in.

Jim.
Chief AvocadoChief of Problem Avocado's

Author

Commented:
?currentdb.Version
4.0

Open in new window


Aha!   Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial