To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107646 Issue #|107646 Summary|MS Access/MDB/Jet: autoselect same workgroup as MS Acc |ess Component|Database access Version|OOO310m11 Platform|PC URL| OS/Version|Windows, all Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|lmamane
------- Additional comments from lmam...@openoffice.org Sun Dec 13 08:25:35 +0000 2009 ------- When connecting through MS Jet to a database (e.g. through OLE DB) supporting user-level security (e.g. MS Access 97/2003 MDB format), the setting for which workgroup to use is left blank, but one is given the opportunity to give a username / password. Username/password is meaningless without the workgroup definition file. The workgroup definition file setting is "hidden" in the advanced options, as a string setting (one does not get a filechooser to set it). This also keeps "File/Open" of a .mdb file to just work in the situation where the workgroup file is not the default "system" one. IMHO, the best resolution would be: Automagically set the workgroup setting to the same value that MS Access uses (when it is installed on the machine, obviously). E.g. Query the MS Access setting from the MS Windows registry and use that. Failing that, promote that setting to the same tab as the username/password, and have a "browse" button that opens a filechooser for that setting. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org