Recent content by 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

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

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

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.

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?