On Friday April 13 2007 1:29 am, john d. herron wrote: > 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_gci >1148271,00.html_ (parts 1 and 2) and > _http://searchopensource.techtarget.com/tip/0,289483,sid39_gci12221 >86,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 There have been some improvements made in Base since version 2.02. You might want to update it to 2.2. Also, where did you get version 2.02? If you got it from Kubuntu, it might have been modified somewhat from the original version from OpenOffice.org. How much RAM do you have on your machine? What were the fields and their field types in the table you were trying to create? I would like to see if I can recreate what happened to you, but I need to know what was in the table that caused the SQL 3700 error.
Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
