>I'm using Management Studio's Tasks->Import data tool to try to import data
>from a MS Access database .mdb file.  But, I keep getting the "the workgroup
>information file is missing or opened exclusively by another user" error
>message.  No, this file isn't open anywhere else.  Yes, I have system.mdw in
>its normal place (documents and settings/me/application
>data/microsoft/access), in windows/system32 and in the directory right next
>to the .mdw file I'm trying to open.
>
>Any clues?
>

"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:8ja3g2dijbdghib8jp3mp7lqnphbseghli@4ax.com...
> The workgroup file location doesn't necessarily have a
> "normal" place - you need to check the registry and make
> sure the registry entry points to the correct location.
> The following article is for linked servers but it has the
> gist of the information and settings:
> http://support.microsoft.com/?id=246255
>
> -Sue
>
> On Fri, 8 Sep 2006 10:16:54 -0500, "0to60"
> <holeshot60_nospam_@yahoo.com> wrote:
>
>>I'm using Management Studio's Tasks->Import data tool to try to import
>>data
>>from a MS Access database .mdb file.  But, I keep getting the "the
>>workgroup
>>information file is missing or opened exclusively by another user" error
>>message.  No, this file isn't open anywhere else.  Yes, I have system.mdw
>>in
>>its normal place (documents and settings/me/application
>>data/microsoft/access), in windows/system32 and in the directory right
>>next
>>to the .mdw file I'm trying to open.
>>
>>Any clues?
>>
>