This is my question.
I will set a password to my database created using MS Access 2007. I will place at my 'Connection-string' statement which in ADO.NET 2.0 using VB 2005. But if I change the password I will have to recreate my setup file and install the new version to the computer.
I heard that, that kind of information (the DBMS password) can be stored in an XML file and then that XML file can be read to get the password. If the DBMS password reset, only have to edit that particular XML file only. Then no need to recompile or create a new setup file.
In ASP.Net 2.0 has a option called as appConfig. But I will develop windows application not web application.
So I want to know how to and where should store my DBMS password in the XML.
Also I want to know how to read that particular XML file and the password and where should i place that XML file when the
system is being developed.
If any you guys want to help me don't think this is a naive idea!
Thanks a lot!