MS JET database engine error: workgroup information file is missing or opened exclusively by another user

permalink · #1 (**permalink**) 02-27-2008, 09:51 PM

Hi,

I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
using Microsoft JET database engine, but it gives me an error saying
" Workgroup information file is missing or opened exclusively by another
user"

This error only exists if i use an MS SQL login with a password but it works
fine with a login without a password. My question is, is there a way around
this with a login that has a password?

Thanks

permalink · #2 (**permalink**) 02-27-2008, 09:55 PM

Hi Tina,

I've the same problem. In fact I've ask the same in sqlserver.dts newsgroup,
but I've no answers yet

What database are you using?
Paradox like me?

I'm still trying things because I would prefer not do disable the passwords
of these files.
If u've found a way, please let me know.

Josep.

"Tina" <Rumi_Akani@yahoo.com> escribió en el mensaje
news:%23XTCLNEqFHA.3520@tk2msftngp13.phx.gbl...
>
>
> Hi,
>
> I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget
> using Microsoft JET database engine, but it gives me an error saying
> " Workgroup information file is missing or opened exclusively by another
> user"
>
> This error only exists if i use an MS SQL login with a password but it
> works
> fine with a login without a password. My question is, is there a way
> around
> this with a login that has a password?
>
> Thanks
>
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode