[thelist] using SQL to create Table column in Access

Anthony Baratta Anthony at Baratta.com
Sun Dec 23 20:39:19 CST 2001


At 06:14 PM 12/23/2001, you wrote:
>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?

Use the "Text" field type. FWiW, varChar can be built with a 4K limit: 
varchar(4000). But note that MS SQL has a limit of 8060 total bytes per the 
row. e.g you can only build 2 varChar(4000) columns.
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."





More information about the thelist mailing list