Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What is wrong with this statement using WITH COMP?

Status
Not open for further replies.

rmuller2

Programmer
Apr 11, 2002
6
NL
CREATE TABLE TestUnicode (
code CHAR(50) WITH COMPRESSION);

Access reports: Syntax error
 
I recently tried to do that, too. It couldn't get it to work.

In response to your question, I did a search of the Knowledge Base. I found the following note:
"Note The WITH COMPRESSION and WITH COMP keywords listed in the previous SQL statements can be executed only through the Jet OLE DB provider and ADO. They will result in an error message if used through the Access SQL View user interface." Rick Sprague
 
okay, thanks!

it also doesnot work via odbc (i am using the database via an jdbc:eek:dbc bridge).

So..bad news!

Ronald
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top