accessing mdb. file in a protected shared folder

Question

Hi all I'm developing an application that should access an mdb file in a protected shared folder in a local net. I have tested it in a non protected shared folder and it works but I have no idea how to make it work in a protected one. I'm using the OleDBConnection Class. I wondered.. has the ConnectionString a parameter capable of doing this (user .. password)? How can I make the application open the folder and close the session once the data had been captured? (to prevent non authorized access). Thank you so much.

Sam Hobbs · Answer

Don't put the database in a protected folder. If you don't have the permission necessary to move it then you must get the person that is responsible to either move the data or give you the access you need. Without the necessary security permission there is nothing you can do.