OLEDB Help
 

I have a problem that I just can not seem to get anywhere with. I have
an exel file that I am connecting to a password protected Acess
database (both on a network drive). I am using OLEDB. The following
is my connection string that works if the database is not protected.

sConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & DBPath

When it is protected I get an error that my reserach seems to indicate
that I need a path to an .mdw file. I do not know much about what this
file is and how to get the address for it. I thought about using ODBC.
Is this the best option and if so can someone give me a example of an
ODBC connection string? Or how I can find the path to the .mdw file?
Will this be a problem if various people will be using the file?
Thanks an advance.