I am trying to access MS-Access DB extended properties like Author,Owner, Last Modified Date, Last Accessed Date etc. using vb.net.
我正在尝试使用vb.net访问MS-Access DB扩展属性,如作者,所有者,上次修改日期,上次访问日期等。
Please help me on this issue...
请帮我解决这个问题......
1 个解决方案
#1
You can access/create/modify different types of properties.
您可以访问/创建/修改不同类型的属性。
at the database level
在数据库级别
- Some of them are specific to the Access database object / Access mdb file and can be managed through JET engine only / DAO database object. Please see the "createProperty" method in VBA/Access Help.
- Some properties are available at the database level through the ADOX object, and can be accessed through an ADO connection, as long as the connection provider supplies these properties: dateModified and dateCreated should then be available at the table\view\proc level.
- When manipulating DAO recordsets (not ADO ones), some extra properties are available at the recordset level, like "lastUpdated" or "lastModified".
其中一些特定于Access数据库对象/ Access mdb文件,并且可以通过仅JET引擎/ DAO数据库对象进行管理。请参阅VBA / Access帮助中的“createProperty”方法。
一些属性在数据库级别通过ADOX对象可用,并且可以通过ADO连接访问,只要连接提供程序提供这些属性:dateModified和dateCreated应该在table \ view \ proc级别可用。
在操作DAO记录集(不是ADO记录集)时,记录集级别可以使用一些额外的属性,如“lastUpdated”或“lastModified”。
At the file level
在文件级别
- Some of them are specific to the fileSystem object, available with VB. They are available at the file level only
- You can manage\define extended properties at the file\document level through the DSOfile object (please google for more details). Such object will allow you to add as many properties as needed such as "Title", 'Author", "Subject" , etc.
其中一些特定于fileSystem对象,可用于VB。它们仅在文件级别可用
您可以通过DSOfile对象在文件\文档级别管理\ define扩展属性(请访问google了解更多详细信息)。这样的对象将允许您根据需要添加任意数量的属性,如“标题”,“作者”,“主题”等。
So, depending on the kind of property you need to access, these might not be available through an ADO connection.
因此,根据您需要访问的属性类型,这些可能无法通过ADO连接获得。
#1
You can access/create/modify different types of properties.
您可以访问/创建/修改不同类型的属性。
at the database level
在数据库级别
- Some of them are specific to the Access database object / Access mdb file and can be managed through JET engine only / DAO database object. Please see the "createProperty" method in VBA/Access Help.
- Some properties are available at the database level through the ADOX object, and can be accessed through an ADO connection, as long as the connection provider supplies these properties: dateModified and dateCreated should then be available at the table\view\proc level.
- When manipulating DAO recordsets (not ADO ones), some extra properties are available at the recordset level, like "lastUpdated" or "lastModified".
其中一些特定于Access数据库对象/ Access mdb文件,并且可以通过仅JET引擎/ DAO数据库对象进行管理。请参阅VBA / Access帮助中的“createProperty”方法。
一些属性在数据库级别通过ADOX对象可用,并且可以通过ADO连接访问,只要连接提供程序提供这些属性:dateModified和dateCreated应该在table \ view \ proc级别可用。
在操作DAO记录集(不是ADO记录集)时,记录集级别可以使用一些额外的属性,如“lastUpdated”或“lastModified”。
At the file level
在文件级别
- Some of them are specific to the fileSystem object, available with VB. They are available at the file level only
- You can manage\define extended properties at the file\document level through the DSOfile object (please google for more details). Such object will allow you to add as many properties as needed such as "Title", 'Author", "Subject" , etc.
其中一些特定于fileSystem对象,可用于VB。它们仅在文件级别可用
您可以通过DSOfile对象在文件\文档级别管理\ define扩展属性(请访问google了解更多详细信息)。这样的对象将允许您根据需要添加任意数量的属性,如“标题”,“作者”,“主题”等。
So, depending on the kind of property you need to access, these might not be available through an ADO connection.
因此,根据您需要访问的属性类型,这些可能无法通过ADO连接获得。