Click to See Complete Forum and Search --> : Microsoft Access DB - Limitations


ArthurKay
10-31-2007, 04:04 PM
Is there a way to pass more than 250-character strings into an Access table? I can't figure it out.

Basically, I'm trying to write restaurant reviews on part of my site but I have to keep each text field under 250 characters in length. I know in MySQL and PostGres the fields can be pretty long, but I can't find the Access configuration to let me do that.

Any help?

edborva
11-01-2007, 06:47 AM
Try using a memo field. This could result in some challanges with white space so try using the <pre><pre/> tag with the memo field contents