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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Error 3251 2
CurrenDB.Name does not work in Access 2003? 5
Exporting from Excel to Access 2
ADO in MS Access to Query Excel File 2
Problems filling Combinationfield with ADO-method 12
ADO connection Open failure 5
Help with ADO connection string - Access 2007 1
Tweak ADO to use a DB password 1

Top