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.
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.
That would resolve the wish for an easy use.
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.)
I am not sure, that I did it right. Running the macro does nothing which
can be seen. I know only little about Basic, but others on this mailing
list are experts.
Does this help?
No, there is no difference. The tables are still readonly.
The ADO dialog has a lot of settings, 21 items. Do you know, whether
there something has to be set to a special value?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
