Avatar of Chief Avocado
Chief Avocado
Flag for United Kingdom of Great Britain and Northern Ireland asked on

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

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 ?
Microsoft Access

Avatar of undefined
Last Comment
Chief Avocado

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
John Tsioumpris

If is not that complex as an application probably it would better to convert it to .accdb...usually a simple import would be sufficient
PatHartman

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 Nasr

You mean mdb format?
Yes!
But you loose upgraded functionality of Access 365.
You need to consider upgrading to the new format.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Jim Dettman (EE MVE)

<<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 Avocado

ASKER
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 Avocado

ASKER
They can work with it, but it must be in Jet 4.0 format.
How can I check the Jet version ?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Chief Avocado

ASKER
?currentdb.Version
4.0

Open in new window


Aha!   Thanks!