Kubuntu 6.06 LTS / OpenOffice.org 2.0.2 is my current environment.
I have a few tables in a MS Access database under Win98SE that I've been
unsuccessfully trying - in several ways - to convert to a native Base
(HSQL) structure. Why? Because it's the last thing that keeps me from
saying "goodbye" to Windows altogether.
The tables are relatively small: the largest is about 1,000 records x 22
fields in size. The DB serves as a base for customer, billing and
collections management in a small business.
I've tried - among other things - to follow Solveig Haugland's suggested
methods for creation from scratch or import into Base outlined in
_http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1148271,00.html_
(parts 1 and 2) and
_http://searchopensource.techtarget.com/tip/0,289483,sid39_gci1222186,00.html_,
respectively.
The moment I try to save a table definition set up from scratch in a
newly created database, one of two things happens:
1) an SQL error 37000 or 2) Base crashes altogether ...and the
work I did is lost in either case.
The same thing happens, after 'importing' (either by dragging or
copying) a selected area of spreadsheet data (with field definitions)
into a new database, when I want to save the work after entering the
table definition criteria.
I'm wondering whether I'm perhaps overly optimistic and overlook
something critical (though I repeated the experiment several times while
scrupulously following the directions) or try to do something
impossible, and whether others in a like environment have encountered
similar difficulties. Or should I try the StarBasic route?
Appreciate your comments or advice.
jdh
