Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE field Path Names

Status
Not open for further replies.

TanyaSealey

Programmer
Jul 17, 2002
10
0
0
GB
Does anyone know how to extract the full path name of a linked file in an OLE field using Access 97 or 2002? Thanks.
 
So this question has been up here since September? I am currently working on that problem as well. I tried extracting and storing the path in a field as the link was established...as provided by the MSKB(KB170531). That didnt work out. Looking at the ole header during debug - I cannot see anything that resembles a path string in there.

I have continued to scour web and books and have not found a solution to this one yet. It may require linking/storing the path through a CommonDialog box - or Drive/Dir/FileListbox controls on a form, and then activating the appropriate application based on file extension instead of using bound ole. Lemme know if you find an easier way out of this. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top