We help IT Professionals succeed at work.

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

Chief Avocado
on
83 Views
Last Modified: 2018-09-17
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

President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
John TsioumprisSoftware & Systems Engineer
CERTIFIED EXPERT
Distinguished Expert 2019

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
CERTIFIED EXPERT
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?
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

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
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

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
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Chief AvocadoChief of Problem Avocado's

Author

Commented:
?currentdb.Version
4.0

Open in new window


Aha!   Thanks!
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.