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.
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 :(
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?
Anybody experience with hube access databases?
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)
thank you
Jens
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
