How do I get to the filename property of a OLE Object field

[sbilbrey]

Hi,

I have an access database with a field of type "OLE Object". I would like to get to the filename of the object. Any suggestions?

Sam Bilbrey
sbilbrey@opentext.com
614.761.7311

 

[CCLINT]

Is the Object embedded or linked?

 

[sbilbrey]

To be honest I am not sure. I did not design the database. I think it is linked, but only because the field comment says "Link to Scanned Picture".

I can tell you when I view the table in Access, the field contents just show "Package" and when I click on it I get an error saying "Cannot find the file..." with the path to the file (and this is the actual information I need, but I need it via VB).

thanks,
sam

 

[CCLINT]

You need to know if it is linked or embedded.

If embedded, then there is no file path.

>Cannot find the file".
If linked, then it looks like the file is missing.

 

[sbilbrey]

Thanks, but I know the file is missing. I am just looking for the path and filename to be available from Visual Basic.

sam