[thelist] using SQL to create Table column in Access

Marc Seyon seyon at delime.com
Sun Dec 23 20:14:33 CST 2001


Seasons' greetings to the list,

Using an Access 2000 database...
When creating Tables with SQL, I know how to set a column's datatype to 
variable length text, but this only gives me a max of 255 characters - 
columnname varchar(255).

Access has a 'memo' datatype, is there a way to create it with SQL?

Thanks.
-marc




More information about the thelist mailing list