You don't need an 80 meg database. You can see an example of this with any of the example databases supplied by microsoft.
The problem seems to be when you link in the third or greater table. For instance - using the file QrySampl.mdb ( available from the MS web site - or ask and I;ll send it along it is only ~670K ) I have done the folloiwng: Connected using MS Access Connected using ADO exclusive mode Connected using ODBC I am using the following three tables only Customers ( 91 records ) Orders ( 830 records ) OrderDetails ( 2155 records ) Now if I create a query that joins Customers to Orders - no problem But - add OrderDetails to the query and BAM takes about 2 minutes to run and the CPU is at 100% for the whole time. ADO exclusive is slightly faster - but not enough to make it usable ODBC is just the same anyway - I am not done just yet with this..so I will put up more as I have it. On 8/16/07, Regina Henschel <[EMAIL PROTECTED]> wrote: > > 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] > >
