Disabling "Unicode Compression" property by SQL Query ( Access )

Is it possible to have a SQ开发者_JS百科L statement in Microsoft Access that can disable the unicode compression property on a column ?

Something in the lines of :

ALTER TABLE MyTable 
ALTER COLUMN MyColumn DISABLE UNICODE COMPRESSION

Yes. You simply need to omit the WITH COMPRESSION keywords when you call your alter statement. Thus, the following would add Unicode compression:

ALTER TABLE [Table1] ADD COLUMN Col1 TEXT(100) WITH COMPRESSION NOT NULL;

If after executing the above, you turned around and executed the following:

ALTER TABLE [Table1] ALTER COLUMN Col1 TEXT(100) NOT NULL;

It would remove Unicode compression.