Access 2010 database with table containing field that contains Word 2010 documents

I have an Access 2010 database that contains a table with a field ("notes") that has a data type = OLE Object. This field contains a single or multipage MS Word document and it opens Word outside of Access. I can make changes to the document and the table saves all the changes in the Access database. The other fields are ID, Lastname, Firstname. In Access I have no problem in opening the table and making changes to the document, but with ASP all I get is "byte.system". I would appreciate any help in being able to open MS Word and display the document.

Re: Access 2010 database with table containing field that contains Word 2010 documents

If you want to do this in ASP.NET, you need to write the document to the Response, which you can do using Response.BinaryWrite(). You also need to provide a way for the user to return the updated document to the web server so that the database can be updated. Here's an article that discusses the basics revolving around storing files in Access with ASP.NET: http://www.mikesdotnetting.com/Article/123/Storing-Files-and-Images-in-Access-with-ASP.NET

Re: Access 2010 database with table containing field that contains Word 2010 documents

Thanks Mike. However, I encountered a problem: CodeFile="AccessUpload.aspx.cs" Inherits="AccessUpload. I do not know where to find the AccessUpload.aspx.cs. Also "Stream" has a problem: The type or namespace name 'Stream' could not be found (are you missing a using
directive or an assembly reference?)

Thank you for your help

Re: Access 2010 database with table containing field that contains Word 2010 documents

gattabria
I do not know where to find the AccessUpload.aspx.cs.

That was the code behind. Create a page with a code behind file.

gattabria
The type or namespace name 'Stream' could not be found

Add using System.IO; to the top of your code behind.

Re: Access 2010 database with table containing field that contains Word 2010 documents

I created a page to put the code behind file but I do not know what code to use? Is it listed? I am new to C#.

Re: Access 2010 database with table containing field that contains Word 2010 documents

I wrote an article about how to do it. If you are having trouble nderstanding that article, I suggest you start at the beginning: http://www.amazon.co.uk/Beginning-ASP-NET-Vb-Wrox-Programmer/dp/0470502215/ref=pd_cp_b_1

Re: Access 2010 database with table containing field that contains Word 2010 documents

That is a book in the UK. Could you please tell me where to put the code behind file? I would really appreciate it. Thank you.

Re: Access 2010 database with table containing field that contains Word 2010 documents

Code behind files are a most basic concept in ASP.NET Web Forms. If you don't want to start with a book, try the introductory tutorials here: http://www.asp.net/web-forms

Re: Access 2010 database with table containing field that contains Word 2010 documents

gattabria

That is a book in the UK. Could you please tell me where to put the code behind file? I would really appreciate it. Thank you.

Hello

In fact you can drag and drop a button onto the aspx pageand you can double click the button and do what Mikesdotnetting's suggestions

Best reguards