Re: [dba-dev] Connecting to MS Access 2007 (*.accdb)

2007-08-26 Thread Frank Schönheit - Sun Microsystems Germany
Hi Regina, >> [MSA 2007] >> Does this help? > > No, there is no difference. The tables are still readonly. Okay, we need to investigate this in the course of your issue then. > The ADO dialog has a lot of settings, 21 items. Do you know, whether > there something has to be set to a special val

Re: [dba-dev] Base functions

2007-08-26 Thread Barbara Duprey
Frank Schönheit - Sun Microsystems Germany wrote: Hi Andrew first thanks to you and Barbary for this collaborative great work! One more point. I did not include certain things on the page, because I am not sure if they belong here: CASE CASEWHEN etx. SOME, EVERY, etc. DISTINCT LIMIT

Re: [dba-dev] Connecting to MS Access 2007 (*.accdb)

2007-08-26 Thread Regina Henschel
Hi Frank, Frank Schönheit - Sun Microsystems Germany schrieb: Hi Regina, Done for the first one in http://www.openoffice.org/issues/show_bug.cgi?id=81043 Thanks. I think, that for the second one no issue is needed, because it is on Microsoft side, that the Jet 4.0 Provider doesn't work.

Re: [dba-dev] Connecting to MS Access 2007 (*.accdb)

2007-08-26 Thread Frank Schönheit - Sun Microsystems Germany
Hi Regina, > Done for the first one in > http://www.openoffice.org/issues/show_bug.cgi?id=81043 Thanks. > I think, that for the second one no issue is needed, because it is on > Microsoft side, that the Jet 4.0 Provider doesn't work. Yes and no. I'd say we need a new "database type" (MS Acces

Re: [dba-dev] Connecting to MS Access 2007 (*.accdb)

2007-08-26 Thread Regina Henschel
Hi Frank, Frank Schönheit - Sun Microsystems Germany schrieb: Hi Regina, Using "Microsoft Access" on the first step of the wizard, doesn't work, only .mdb-files are selectable. Using "ADO" with provider "Microsoft Jet 4.0 OLE DB Provider" is not possible, connect only to .mdb-files. No is

Re: [dba-dev] Base functions

2007-08-26 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Andrew first thanks to you and Barbary for this collaborative great work! > One more point. I did not include certain things on the page, because I > am not sure if they belong here: > > CASE > CASEWHEN > etx. > > SOME, EVERY, etc. > > DISTINCT > > LIMIT > > What do others think, should

Re: [dba-dev] Connecting to MS Access 2007 (*.accdb)

2007-08-26 Thread Frank Schönheit - Sun Microsystems Germany
Hi Regina, > Using "Microsoft Access" on the first step of the wizard, doesn't work, > only .mdb-files are selectable. > > Using "ADO" with provider "Microsoft Jet 4.0 OLE DB Provider" is not > possible, connect only to .mdb-files. No issue for this, yet - blame us. Do you mind submitting one?