Getting location of OLE object via VBA

[Zelda87]

Hello All,

I have an OLE Object type field in an Access database. The objects in
this field are files which are linked rather than embedded.

My question is, how can I get a given object's location as a string?
I have tried the following:

Dim MainTable As Recordset
Dim PicField As Field

MainTable.MoveFirst
MsgBox PicField.<x>

where <x> is all the properties I thought might yield the
path-location of the file the object was linked to. Unfortunately,
none did. Are there other methods/objects I need to be using perhaps?
Google and the newsgroups haven't been much help so far.

Any help would be appreciated.

Thanks
-Nitin

[Tom van Stiphout]

On 18 Nov 2004 00:06:23 -0800, ni************@gmail.com (Zelda87)
wrote:

When I had to recently do this, I used these KB Articles: Q170531,
Q114124. The header of an OLE Object is not officially documented, but
if you review the first 200 bytes or so, you'll start seeing patterns
you can use.

-Tom.

Hello All,

I have an OLE Object type field in an Access database. The objects in
this field are files which are linked rather than embedded.

My question is, how can I get a given object's location as a string?
I have tried the following:

Dim MainTable As Recordset
Dim PicField As Field

MainTable.MoveFirst
MsgBox PicField.<x>

where <x> is all the properties I thought might yield the
path-location of the file the object was linked to. Unfortunately,
none did. Are there other methods/objects I need to be using perhaps?
Google and the newsgroups haven't been much help so far.

Any help would be appreciated.

Thanks
-Nitin