Oh yes - XP SP 2 all updates as of yesterdays release from MS OOo 2.3m_1
On 8/16/07, Andrew Jensen <[EMAIL PROTECTED]> wrote: > > 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] > > > > >
