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 ?
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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?
Why are you avoiding converting to .accdb format?
You mean mdb format?
Yes!
But you loose upgraded functionality of Access 365.
You need to consider upgrading to the new format.
Yes!
But you loose upgraded functionality of Access 365.
You need to consider upgrading to the new format.
<<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.
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.
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 :-)
ASKER
They can work with it, but it must be in Jet 4.0 format.How can I check the Jet version ?
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
?currentdb.Version
4.0
Aha! Thanks!
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
