DBD::ODBC download

[yssirhc]

I created a database within MS Access - no SQL code - and set a field to "Memo". When I go to my web app that inserts some form data into the database, if I type too much into that one field on the form, I get "Invalid Precision Value".

I've been looking online and found this:
This error message is received when trying to store more than 255 characters in a MEMO field. The problem is (to my knowledge) an error in the MS Access ODBC driver. The problem is fixed by setting the data_type of the column to SQL_LONGVARCHAR in add_columns. SQL_LONGVARCHAR is a constant in the DBI module.

Only I have no idea how to set the data type of the column to longvarchar. The server language I'm using is perl, but I didn't create the table or database with sql, which is what I think this solution is assuming. I created the table by going into Access and clicking on "New Table".

Does anybody know how I can fix this so that the memo takes more than 255 chars?

I thought I'd try downloading the most recent DBD::ODBC module. I went here: http://search.cpan.org/~mjevans/DBD-ODBC-1.20/ODBC.pm and downloaded DBD-ODBC-1.20.tar.gz but I'm not sure where I'm supposed to download this to. Right now it's unzipped on the desktop.
I'm clueless right now if I'm even going about this the right way.

[holyhttp]

Run a SQL query to change the format of that column to just "text"

[yssirhc]

I had it set as text originally and it was giving that "invalid precision value" error. so I checked Access's help, which said that text fields can only hold 255 characters and that memo fields can hold about 65,000 characters.

Even though it's set to memo though, it's still giving that same error message.