910 questions
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:
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(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)
StewartBW
1,765
Reputation points
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
Microsoft 365 and Office Access Development
Microsoft 365 and Office Access For business Windows
{count} votes
-
![](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)
KOZ6.0 6,655 Reputation points2024-03-31T01:41:37.1366667+00:00 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
Sign in to comment
1 answer
Sort by: Most helpful
-
![](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)
Tom van Stiphout 1,861 Reputation points MVP2024-03-30T22:13:50.02+00:00 -
StewartBW 1,765 Reputation points
2024-03-31T01:55:25.4633333+00:00 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)
Albert Kallal 5,586 Reputation points2024-04-01T22:04:31.29+00:00 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.
Sign in to comment -