Hello,

I am currently using VBA for User interface development and MS SQL Server 2019 as my Database.

I WANT TO KNOW -
1. How Can we store DB credentials like (Server Name, UID, PASS, DB Name) Securely using VBA
2. Every time applications loads it read the DB Credentials
3. Whenever an Admin wants he can Read and Modify these credentials during Run time (while VBA application is running).
Also I want DB credentials to be secure so that no other user can read/change it but only An admin can manage it

if it Can BE DONE USING XML or SYSTEM SETTING than how to do it !!!!

Please help