There are many examples you can use here.
--please don't forget to
Accept as answer if the reply is helpful--
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?