Programatically open a file stored in a SQL backend from an ADP project

[Chuck]

Hi,

I have MS Word files stored in a SQL backend. I need help with the VBA code
so that I can open one of these files when clicking on a button.

Right now the files are on a server and I'm using the Documents.Open method
to open the files. It would make life much simpler for our distributed
users if these files were actually stored in the database. These are
read-only templates and there are just a few of them so this approach seems
like the way to go.

So all I need right now are a few pointers as to how I would open a file
stored in a table.

Thanks

 

[John Nurick]

Hi Chuck,

AFAK you can't, but need to have your code save the document to disk
first (e.g. to a read-only file in the user's Temp folder).