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 -- Dipl. Ing. Mechtilde Stehmann ## Observer OpenOffice.org: lang/DE ## Freie Office-Suite für Linux, Mac, Windows, Solaris ## http://de.openoffice.org ## Meine Seite http://www.mechtilde.de ## PGP encryption welcome! Key-ID: 0x53B3892B --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
