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

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