unicode compression

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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');
 
Back
Top