here's my connection string for database over network.. for security purposes i put a password on my database... then for additional security i put a password on the shared folder... but i dont know the code to how open it...
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\warehouse-encod\Database\WI.mdb;Persist Security Info=False;Jet OLEDB:Database Password=thankyou"please help.. badly needed.. thanks
Well first, you are going to have to impersonate a user that has the rights to the folder...
http://support.microsoft.com/default.aspx?scid=kb;en-us;285879
Then see http://www.connectionstrings.com for proper formatting of your connection string.
Good Luck
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.