Mechtilde wrote:
Hello Jens,
Jens Ansorg schrieb:
hi,
I try to use OOO Base 2.2.1 as a front end to a MS-Access mdb file.
I guess you are working under Windows
The database file is about 80Mb in size.
I sucessfully created the link to the database using the "Microsoft
Access" Connector.
I can see all contained tables and also access all data within.
Ok.
Trouble starts when I try to create Queries across more than one table.
Do you set the relation between the tables in the query
No matter whether I enter the SQL manually or use the wizard or the
design view: when I try to view the query result - and even when I just
try to save the query without viewing the result first - OOO Base starts
to use 100% CPU and that's it ... forever until I kill it :(
Do you try small parts of a query? Does this work?
I tried to do queries across several tables with a small sample access
database and this works so I suspect that OOO has trouble dealing with
the huge amount of data here?
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
Anybody experience with hube access databases?
I don't understand what "hube" means.
I converted some Access DBs to mysql and OOo
I cannot provide the database file in question; it is available
(although for a small fee). If you go to
http://www.navigraph.com/www/fmsdata.asp, the last entrry to download
"Wilco/Feelthere 737/777, ERJ, Legacy, Citation X" is a windows setup
that installs this mdb file on your harddrive (but you have to be logged
into the site and for that you have to pay)
Regards
Mechtilde
Jens, your best bet might be to copy the tables and queries into a new
database so there will only be embedded data rather than a link to the
Access tables. Briefly, you'd have your current database open at its
main view, and do a File | New | Database. Then you can select Tables on
your current database and the new one, and drag-and-drop each table into
the new one and follow the resulting dialogs (making sure each table has
a primary key), then do the same with Queries and any other things
you've set up under OOo in the current database. If you need more
details on this, there are people here who can help. Having the data
internal rather than external should dramatically improve performance.
(I think this is probably what Mechtilde was referring to in her
response about converting Access DBs.)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
