Unicode Compression

[Guest]

Hi All,
I'm using Access 2k
Using SQL I have been creating tables with some text fields.
Something along the lines of:

CREATE TABLE MyTable (MyTextField TEXT(50));

But - it is defaulting the Unicode Compression property of that table to be
NO and I don't want that.

So ... I try:

CREATE TABLE MyTable (MyTextField TEXT(50) WITH COMPRESSION);

But it throws back an error on the WITH.

Does anyone know why? I even pulled a similar query off MSDN and that
crashed on the WITH command also.

I have also tried using "WITH COMP" to no avail.

Regards,
Peter Hill

 

[Sylvain Lafontaine]

Hi,

Sorry but this newsgroup is about the use of ADP (Access Data Project) for
accessing an SQL-Server as an backend database and has nothing to do with
the SQL syntax of Access for manipulating an Access database (or MDB file).

You should ask you question in a more appropriate newsgroup.

(However, some SQL statement can be executed only through the Jet OLE DB
provider and ADO and will result in an error message if used through the
Access SQL View user interface. I suspect that your error is coming from
that.)