[thelist] using SQL to create Table column in Access

[Marc Seyon]

At 12/23/2001 11:39 PM, you wrote:

> >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?
>
>This is a bit ambiguous.
>
>You mean use SQL to alter the table in Access? Or do you mean create a
>memo-like field in Microsoft SQL Server?

The latter, create a new table, with a memo-like field. Using Access, not 
SQL Server, if it makes a difference.

thanks.
-marc