URGENT:: password protecting

[Mag-Net]

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

[Clunietp]

'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

[Mag-Net]

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!

[Clunietp]

Lets see your code that generates the error

[Mag-Net]

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! :)