ODBC database

[ythagerty86]

I am linking to an ODBC database, when I do it comes up with a login box. Is there coding to automatically log in to that ODBC database. I do not want the end users seeing the login box. I want that to be auto. Any Suggestions?

 

[SOS]

When you go to select the tables to link to there is a SAVE PASSWORD box at the bottom right corner of the form.

 

[ythagerty86]

I know, but with the security of the ODBC, you have to change the password every 60 days and I dont want to have to relink every 60 days. That's why I need some coding so the end users can get in without me having to relink the the tables from the ODBC.

 

[Banana]

First: I want to point out that this is a security risk to save password. It's saved plaintext and I doubt that the DBA would be happy to know that his precious database's credentials are being sprinkled all over the network. Caveat Lector.

Second: How do you intend to obtain that password when it changes? You'd have to obtain it somehow in order to relink the tables.

 

[ythagerty86]

I understand the security risk and have already talked to administrator of that ODBC. Really this isn't what I am asking. I am asking for CODE that will logon to the ODBC without the end user having to see the dialog box. This will not effect the security, because of groups and one user name per group, with that password being for that one user name. I don't want the tables relinked. I am not saving the password at ODBC linking, I want the code to fill in the username and the password auto. when the login box appears.

 

[ythagerty86]

I am also the one that changes the password for the group.

 

[Banana]

Alright, but the point is that you still have to obtain the password from *somewhere* for the code to get authenicated.

To provide an example. Let's say you change the password, and you write the password into a text file and save it on a network file share. Your Access application's code can then be directed to look in the text file for the new password, and concatenate this into a DNS-less connection string so it'll always be authenticated everytime it opens even when the password has been changed (and the text file updated accordingly).

So, you have to figure out where to put the password in a place so that all applications that needs it can obtain it.

Did that help?

 

[ythagerty86]

I understand that and will put that out on a drive only shared by the users. Buy now can you help me with the code to be able to do this. I need the code, not a programmer so I am stumped

 

[SOS]

Try doing a Google search for "DSN less connection"

 

[HiTechCoach]

I find it best to use Windows Authentication / Trusted Connections with ODBC connections. This way you do not have to working about the passwords changing.

This may help:

Using DSN-Less Connections