OpenOffice vs MySQL read-only

[Bill Campbell]

I've been trying to learn my way around openoffice on SuSE 8.1,
in particular interfacing with MySQL.  The basic problem is that
mysql tables show up as read-only even though they have the
proper primary keys, and the user at hostname has full privleges in
the mysql database (e.g. ``grant all on *.* to ...'').  I have
created a table from openoffice, and added fields including one
integer field as the primary key.  So far I haven't been able to
add, modify, or delete records from the tables using openoffice.
Furthermore, when I go to edit the table, all fields appear to be
read-only in the edit mode.

I've tried this using both myodbc->unixodbc and jdbc with the
same results.  The results are the same on two different mysql
servers.  Here are the various RPM versions on the systems:

              Version                         System
              OpenOffice_org-1.0.1-25         SuSE /bin/rpm
              unixodbc-2.2.5-20030227shared   openpkg rpm
              myodbc-3.51.05-20030116shared   openpkg rpm
              mysql-connector-java-3.0.6
              MySQL Servers
              mysql-3.23.54a-20030116         openpkg rpm
              mysql-3.22.32-1S                Caldera OL 3.1

What might I be doing wrong?

Bill
--
INTERNET:   bill at Celestial.COM  Bill Campbell; Celestial Software LLC
UUCP:               camco!bill  PO Box 820; 6641 E. Mercer Way
FAX:            (206) 232-9186  Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/

The day-to-day travails of the IBM programmer are so amusing to most of
us who are fortunate enough never to have been one -- like watching
Charlie Chaplin trying to cook a shoe.