How to get "extended properties" of Access DB using OLEDB or ADO connection
1 answer
You can access / create / modify various types of properties.
at the database level
- Some of them are related to Database Object Access / mdb file access and can only be managed by JET engine / DAO database object. See the createProperty method in the VBA / Access Help.
- Some properties are available at the database level through the ADOX object, and can be accessed through the ADO connection if the connection provider of the properties: dateModified and dateCreated must be available at the \ view \ proc table level.
- When manipulating DAO (non-ADO) recordsets, some additional properties are available at the recordset level, such as "lastUpdated" or "lastModified".
At the file level
- Some of them are related to fileSystem, available with VB. They are available in the file only level
- You can control \ define extended properties on the \ document level through the DSOfile object (please see Google for more information). Such an object will allow you to add as many properties as needed, such as "Title", "Author", "Subject", etc.
So, depending on the type of property you need to access, they might not be available through the ADO connection.
+3
source to share