Unicode Compression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Hill - 26 Jul 2005 03:38 GMT

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

Reply to this Message

Sylvain Lafontaine - 26 Jul 2005 04:31 GMT

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.)

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> Hi All,
> I'm using Access 2k
[quoted text clipped - 20 lines]
> Regards,
> Peter Hill

Reply to this Message