Memo field add/update failure

[petejha]

I am working on a new website using asp with an Access database. I have
a problem with a Memo field when adding/updating - the SQL fails with

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC Microsoft Access Driver]Invalid precision value

when I try to add or update more than 255 characters. If I remove the
extra characters, the add/update works fine.

I tried an experiment where I created a record directly in the table
with about 700 characters in the Memo field. I shipped this database to
the website and found I could retrieve and display the data with no
problem but I could not save that same data without removing the extra
characters.

I have trawled through lots of user group entries and found lots of
instances of truncating Memo fields but in every case that I've seen
the solution has been to remove GROUP BY, DISTINCT, or a similar
condition on the query. My SQL is straightforward and I am using a
preset query (stored procedure) in Access like this (there are actually
lots of fields but I have left most out for ease of reading):

connString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("mydb.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connString
conn.qUpdTable, mymemo, myinput

where 'qUpdTable' is the UPDATE statement, ''mymemo' is the Memo field
and 'myinput' is the input parameter. The UPDATE statement in Access
looks like this :

UPDATE Mytable SET MyMemoFld = [mymemo]
WHERE MytableID=[myinput];

Can anyone shed any light on why this should fail and how I can resolve
the problem?

Thanks in hopeful anticipation.

PJ.

 

[Bob Miller]

Did you check your table's field size?

I am working on a new website using asp with an Access database. I have
a problem with a Memo field when adding/updating - the SQL fails with

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC Microsoft Access Driver]Invalid precision value

when I try to add or update more than 255 characters. If I remove the
extra characters, the add/update works fine.

I tried an experiment where I created a record directly in the table
with about 700 characters in the Memo field. I shipped this databas
to
the website and found I could retrieve and display the data with no
problem but I could not save that same data without removing the extra
characters.

I have trawled through lots of user group entries and found lots of
instances of truncating Memo fields but in every case that I've seen
the solution has been to remove GROUP BY, DISTINCT, or a similar
condition on the query. My SQL is straightforward and I am using a
preset query (stored procedure) in Access like this (there ar
actually
lots of fields but I have left most out for ease of reading):

connString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("mydb.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open connString
conn.qUpdTable, mymemo, myinput

where 'qUpdTable' is the UPDATE statement, ''mymemo' is the Memo field
and 'myinput' is the input parameter. The UPDATE statement in Access
looks like this :

UPDATE Mytable SET MyMemoFld = [mymemo]
WHERE MytableID=[myinput];

Can anyone shed any light on why this should fail and how I ca
resolve
the problem?

Thanks in hopeful anticipation.

PJ

 

[petejha]

There is no size for a Memo field, unlike a Text field - you don't get
a Size option to set. It just takes any number of characters up to
65,000 or so.

Thanks for the suggestion though.

PJ.