How to write and modify OLE objects column in access 97

[s_muhilan]

Hi

I want to do the following in Vb.NET 2005 windows form

1. saving Ms-office documents in Access 97 using VB.NET

2. Opening the saved document in Access 97 using VB.NET and show to user after user clicking a link correspoding to the record

3. After user modified the document/xls file, it should once again save into Access 97 database.

I read the following document from support.microsoft.com
HOW TO: Read and Write a File to and from a BLOB Column by Using
ADO.NET and Visual Basic .NET

This document explains how to open and save a document from BLOG fields.

But without physically saving the document into local hard disk, is it possible to open in OLE control? and after modifing saving back to Access 97 database.

Regards
S. Muhilan

 

[jmcilhinney]

I'm fairly sure it's not possible. You would have to save the files to the user's Temp folder and then re-save them from there before deleting them.

 

[s_muhilan]

Re: your reply

Hi,

Our client want to do this way only. Is there any other way?

Regards
S. Muhilan