Issue 107646

Summary:	MS Access/MDB/Jet: autoselect same workgroup as MS Access
Product:	Base	Reporter:	lmamane <lionel>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	UNCONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOO310m11
Target Milestone:	---
Hardware:	PC
OS:	Windows, all
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description lmamane 2009-12-13 08:25:35 UTC

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.