Storing and Modifying DB Server Credential using VBA securely

[ronakj16]

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

[arnelgp]

1. store it in table.
2. read it from table. if you have the tables Linked, then you need to delete/re-create them
or refresh their links.
3. read them from the table.
4. credentials are stored on each linked tables so it cannot be secured.
unless you are opening the tables from VBA and there is no
linked tables.