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 Access 2007 or so)
complementing the existing MS Access type, since the latter simply
pre-fills settings for an ADO connection. Let's see.
>>> Using "ADO" with provider " Microsoft Office 12.0 Access Database Engine
>>> OLE DB Provider" is possible. I can see the tables, but they are all
>>> readonly.
>> Does changing the "ignore driver privileges" setting in the advanced DB
>> properties change this?
>
> There is no such setting, neither in the ADO-dialog nor in OOo. If I'm
> wrong, please point me to the setting.
Ehm - you're right, neither ADO nor MSA connections have this setting in
the UI. At least for ADO I fail to see the reason.
Try (in basic)
oDS = createUnoService( "com.sun.star.sdb.DatabaseContext" ). _
getByName( YourNameHere )
oDS.Settings.IgnoreDriverPrivileges = TRUE
(after this, you need to programmatically or in the UI save the
respective database document, to make the setting persistent.)
Does this help?
Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
