c# - How can I get all the data types specific for a certain version of MS Access or/and every versions of MS Access? -
I am trying to list data types from Microsoft Access 2000-2007 (based on MS Access database version) A C # program I want my program to be able to open MS Access 2000-2007 database If I open a MS Access 2003 then I want to be able to use the datatype of any data for MS Access 2003 and list those data types in a combo box. If I open the MS Access 2007 database then it will be for the data type of data for MS Access 2007 ... I was wondering if I can use ACEDO (ACADOO is only compatible with MS Access 2007?) I am Also, how can I get all the data types for a specific version of MS Access or / and every version of MS Access (in my case 2000-2007)?
ACEDAO is backward compatible with all versions of the jet. But compatibility is provided in various ways. For example, if you look directly at the ACEDAO object model, you will see that there is a field data type and a field 2 data type. In Access 2007, you do not see this, my guess is that the field data type is for MDBs (Jet 4 and earlier), and Field 2 data type is for ACCDB, because ACCDB has new data types that have the first There is a lack of field type properties and methods.
For example, in field 2 data type there is an appendaneous property which is used in the app-only memo field, a new feature in the ACE Another new asset is ISComplex, which I'm guessing is to support the new multi-value data type. I also do not recognize loadfreefile and savoofile methods as well as its purpose.
Now, this is just one object in the DAO library where there are differences depending on the file format you are using, I have not seen such other changes, but they can be there too Are there.
Therefore, you should still know what is applicable to different versions, although ACEDO is giving you a superset to be able to work on all the older versions. If you only have to work with ACCDB and Jet 4 MDB, then I think ACEDO will be enough.
But, I just started to explain what I think is what you want to do.
Comments
Post a Comment