Here's how I do it,
Code:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=S:\Leave\Leave.mdb;Persist Security Info=True;User ID=admin;Jet OLEDB:Database Password=MYPWD
Why is there a smiley face in your connection string?