Mechtilde wrote:
Hello Jens,
Do you set the relation between the tables in the query
The relationships (and primary keys, index) between the tables are
already within the access db. When I open it using "Microsoft Access" or
"ADO" I can see the defined relationships in Base.
Do you try small parts of a query? Does this work?
I can query any table on it's own. but when I use a join to combine two
tables, no matter how many columns, I get the freeze. ALso, I added a
WHERE to limit the number of returned datarows to 10 - but this also
makes no difference.
How many rows do your tables have
I think it's maybe a problem bettwenn OOo and Access. I work with OOo
and mysql with more than 15.000 rows
The two tables I need are about 100.000 and 7.000 rows
I tried again and created a simple query in the SQL view:
SELECT l.id, l.airwayId, w.ident FROM AirwayLegs AS l, Airways AS w
WHERE l.airwayid = w.id AND l.id < 10
I did not check the result, I just hit the "save" button.
OOO Base starts consuming 100% CPU (fortunately only one core of my dual
core system). I left it running and checked back later: It got finally
saved. As per taskmanager, the CPU Time for the soffice.bin process is
about 12 minutes
The worst thing about that is that this operation blocks the whole
office suite, one cannot even work with another part, writer or draw,
since the whole suite is blocked :(
Anybody experience with hube access databases?
I don't understand what "hube" means.
sorry, "huge"
I converted some Access DBs to mysql and OOo
I don't really want to work with that database in OOO Base. I just
wanted to use OOO Base as a tool to write some queries to be used in
some app I'm developing. I use another query tool for now.
thanks
Jens
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
