URGENT:: password protecting

How please ppl do i password protect my database and still access it thru vb? i want to use a adodc control, and a login box, i cant establish a connection when i have a password set, and it says something about a workspace file or something.. i am totally stuck, this has to be done by the 19th July, HELP ME! thanks

Code:

---

   
    'uses ADO 2.x
    Dim cn As Connection
   
    Set cn = New Connection
   
    cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Nwindnew.mdb;Jet OLEDB:Database Password=password;"

---

Just change your connection string as I showed above

Hey man, there is one word for you: "genius", thank you so much, you saved my life... Do you know how to get rid of that of that multiple OLE DB Step error or something that i asked in that other thread?

THANKS!

Lets see your code that generates the error

I really am not sure why i was getting the error, i got fed up with 98 so i rebooted into NT and done a bit of fiddleing and fixed it all, I dont get the error now and everything is running smoothly, thanks guys! :)