OLE Objects

[rleestma]

Hi there...

I'm an Access guy, and I am just now starting to get my feet wet with ASP. I have a million dollar question, that being is there a way that I can embed OLE objects, meaning Word Documents, Power Point Presentations directly IN the access database (I know yes to that for sure) but then be able to insert, edit, retreive and store those embedded objects directly out of the record?

THANKS SO MUCH!!!

 

[mlawson]

HI there,

Unforunately you will find that the size of your backend database will expand beyond all feasibility and become cumbersome and the risk for crashing or viruses increases correspondingly. (Enough to put you off yet?)
The way forward (as far as I am concerned) is to create a physical text link to the file concerned within the database and avoid OLE completely. To do this create a field in your file database like 'File_location'. Then type in a physical link, ie the location of that file relative to your web root (so ../files/word.doc). Then I normally have a filename field which I bind to the page and make that a link to the actual file. The reason for this is that some people who I deal with use repetitive naming for files they have uploaded (ie tut1, tut1, tut1a,etc, that's academics for you!).
To create a link based on the filename of the file pointing to it's real location, code like this will facilitate downloading that file.

<a href=&quot;../fileuploads/<%=(rsQryFileUpload.Fields.Item(&quot;filelocation&quot.Value)%>&quot;><%=(rsQryFileUpload.Fields.Item(&quot;filename&quot.Value)%>&quot;></a>

Hope this helps.

Have fun

M