Inserting to Memo fields using ODBC

[Rieekan]

I'm attempting to save values to a memo field in an Access database, but when I attempt to insert with the statement below, it throws an error of 'Invalid Precision Value'. The problem is occurring when I have a value for $comments that is greater than 255 characters. (The max size for a Text field in Access).

Has anyone ran into this before and have any suggestions on how to fix this?

- Rieekan

 

[BDC2]

Does this help?

http://www.geocrawler.com/archives/3/183/2000/12/0/4891890/

BDC.