Authenticate by code

[weatherb]

I am creating a read-only application that links data from several ODBC sources--each requiring a different username and password--and would like to spare the user from having to provide those usernames and passwords. No security issues. I think I would use the OnOpen event of my interface form, but I don't know where to go from there.

 

[Muttley]

Try opening an ODBC Workspace, putting the necessary user IDs and passwords in your connection and selecting dbDriverNoPrompt or dbDriverComplete (default) as your connection options argument.