Hi Jens,
Jens Ansorg schrieb:
hi,
I try to use OOO Base 2.2.1 as a front end to a MS-Access mdb file.
The database file is about 80Mb in size.
I sucessfully created the link to the database using the "Microsoft
Access" Connector.
Do you have tried an ADO connection too?
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.
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 :(
Can you please post an example SQL statement?
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?
I would like to try it on my PC, but how to get a 80MB access database file?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]