I am using the following code and DAO to insert a record into a FPW2.6 table with two fields Status - numeric and WorkReq - Memo.
On Error GoTo ErrRoutine
Dim dbHermes As Database, rcsTemp As Recordset
Call ReadINIFile
Set dbHermes = OpenDatabase(gDatabaseLocation, False, False, "dBASE IV")
Set rcsTemp = dbHermes.OpenRecordset(gDatabaseName, 2)
rcsTemp.AddNew
rcsTemp("WorkReq") = strMessage
rcsTemp("Status") = 1
rcsTemp.Update
rcsTemp.Close
dbHermes.Close
DBUpDate = True
Exit Function

Now, "Status" inserts fine but when I write "WorkReq" DAO returns an error: "Field is too small for data size". "WorkReq" is a memo field and if I write 28 characters or less the field inserts fine. Is this an issue of too much data hitting the pipe at once or do I need a different driver?

Is this a Chunk issue because I am writing a to a data source of undefined size?

Thanks for any and all help with this problem.

Jim Smith