ADO prop/method to retrieve Access 'HyperlinkBase' DocProperty?

R

RespDave

I'm inserting records into a table in an Access database from an external
application using ADO. One of the fields is defined as a hyperlink. I
figured out the #displayname#path#subpath# formatting, but at issue is how to
describe a relative path (to a file in the local file system) - I'd like to
programmatically retrieve the database DocProperty 'HyperlinkBase' so I can
properly specify the relative path. Is there some Jet provider-specific
schema that I can use to get this info for the Access file the ADO Connection
object references? I find example code for getting hyperlink base and other
builtin document properties for Access, but only using DAO automation.

Access 2003/Microsoft.Jet.OLEDB.4.0/ADO 2.8

Thanks,

Dave
 
Top