unicode compression

[Steve]

How do I code in the "Create Table" Statement to turn on
unicode compression in Access VBA 2000. I have tried "With
Compression" but with no luck. Thanks.

Steve

 

[Allen Browne]

You may need to execute the query statement under ADO to get this to work.

Syntax example:

CREATE TABLE MyTable
(Amount CURRENCY NOT NULL DEFAULT 0,
Item TEXT(100) WITH COMP NOT NULL DEFAULT 'Cash Sale');