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_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
I do not know Kubuntu but certainly on Windows XP one can import an Access
database by right clicking on the quickstart icon, click Database select
"connect to an existing database" and from the drop-down menu select
Microsoft Access (on mine it's hidden at the top of the list) and follow the
screen instructions from there.
I imported an Access databaseabout twice the size of yours without problem,
but as I indicated I have no idea whether one can do this using Kubuntu.
Ron Ferguson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
