This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 77%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Hey everyone
This wiki table is referiong to different Access ACE database versions:
https://en.wikipedia.org/wiki/Access_Database_Engine
ie ACE 14 supports database version 3.x and 4.0
ACE 15 and 16 only support database version 4.0
My question is that when creating new accdb or mdb blank database files using Access 2010 or 2016 can we specifiy that database version?
Because I will need to work with those database files using OleDbDataReader in .net framework and mostly Access database engine 2010 will be installed, so using .net can we retrieve the database file version?
Any info can be helpful and greatly appreciated
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 79%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK0%3C/text%3E%3C/svg%3E)
How's this?
「OleDbConnection.ServerVersion Property」 https://learn.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.serverversion?view=dotnet-plat-ext-8.0
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
How are you creating the database? If programmatically there is no such choice in DBEngine.CreateDatabase.
If manually, you can create a database, and then Save As an older version, such as here in Access 365:
Hey Tom, thank you for the tip but that's the generic format, accdb vs mdb legacy and mdb
Looking at the wiki table, I mean ACE 14 15 16 database version.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 46%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
The data engine version is a VERY different concept then the version of the database file created. If you are using ACE, and create a accDB file, then you should be just fine, and that will create a access 2010 compatible database which can be opened with ACE 14 and later. With a mdb file, then that's probably a more complex answer, but this means that creating a accDB file will thus create a database that can be opened with Access 2010 and onwards.