dsnless but require userid password

Donnyc 1 Reputation point
2021-12-04T20:40:24.713+00:00

is there way to require a userid /password using dsnless?

i've setup dsnless links, and been using for an access app linked to mysql on AWS. I also set up a simple login form, then vba runs connect query using userid and password from form, and just runs like "select 1".

however, i see now that any user/password on form works and it allows access. can i still use dsnless, while also checking credentials?

thanks!

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
798 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. Dave Patrick 426.1K Reputation points MVP
    2021-12-04T21:13:19.82+00:00

    There are many examples you can use here.
    https://www.connectionstrings.com/

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments No comments

  2. Donnyc 1 Reputation point
    2021-12-04T21:19:24.303+00:00

    thanks - i have the string and links all set up - was asking how to implement a login that will actually test the credentials given, before providing access to the already linked tables..

    0 comments No comments

  3. Donnyc 1 Reputation point
    2021-12-04T21:34:35.83+00:00

    thx - dont need the connection string, already have linked successfully with dsnless.

    The Issue I have is authenticating when open app...when i enter wrong password into my input form, it then plops that wrong password into connection string, and query succedes any way! (seemingly as long as entered password length is same on mysql db!)

    dont understand this -

    0 comments No comments

  4. Dave Patrick 426.1K Reputation points MVP
    2021-12-04T21:38:24.383+00:00

    Ok, gotcha, seems you need the password passed into the string as a variable.

    0 comments No comments

  5. Donnyc 1 Reputation point
    2021-12-04T21:46:14.93+00:00

    yes, thats what i do with vba. When I enter wrong password in form and put into connect string, it still works with wrong password. It looks to be using cached userid and password (correct one), and not the wrong one entered in form and then in connection string somehow..