Issue 107646 - MS Access/MDB/Jet: autoselect same workgroup as MS Access
Summary: MS Access/MDB/Jet: autoselect same workgroup as MS Access
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO310m11
Hardware: PC Windows, all
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-12-13 08:25 UTC by lmamane
Modified: 2013-02-07 22:38 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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.