Inserting/Updating Access memo fields using OleDB

  • Thread starter Thread starter microsoft.public.dotnet.languages.csharp
  • Start date Start date
M

microsoft.public.dotnet.languages.csharp

I am using C#, ASP.Net and Access 2000. In my table in the database,
one of my fields is a memo field. I have written an ASP.Net application
that I have to use OleDB to connect to the Access database. I cannot
figure out what you have to do to perform an insert or an update on a
memo field. I read some information that says you have to treat it like
a BLOB field and/or use a FileStream. I don't have a clue.

Anyone know what the trick is to inserting or updating a record that
contains a memo field with OleDB? I only get errors.

Thanks,
Marty
 
I am able to access it just like any other text field. When very large text
is to be managed, separate them into different segments.
-kPraveen
 
Thanks for the reply but that is not possible in this situation. When I
created the parameter for the memo field, I assigned it as a
OleDBType.VarChar. Anyway, I need a solution.

Anyone have an example with a solution?


Thank you,
Marty
 
Back
Top