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]

Reply via email to