I am using Base in OOo 1.9.95 on Win2000 SP4.

A database is created and registered as a HSQL type, using all defaults.

When creating a table using the wizard, at step three (Set Primary Key) if the
"Create a primary key" box is checked, "Automatically add a primary key"
radiobutton is selected and "Auto Value" is checked an error pops up when Finish
is clicked and the wizard will not prodeed until "Auto Value" is unchecked.  The
error that pops up reads "Unexpected token: AUTO_INCREMENT in statement [CREATE
TABLE "Assets"("ID" INTEGER NOT NULL auto_increment]

If I then try to edit the table and change the Primary Key to AutoValue=Yes the
change is not saved when save is clicked, in fact it reverts to No.

Am I doing it wrong?