Consulting

Results 1 to 2 of 2

Thread: Storing and Modifying DB Server Credential using VBA securely

  1. #1
    VBAX Regular
    Joined
    Feb 2019
    Posts
    23
    Location

    Question Storing and Modifying DB Server Credential using VBA securely

    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

  2. #2
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •