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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
?currentdb.Version
4.0Aha! Thanks!