Using the connection designer, I can set the preference for displaying the ODBC login prompts to Always, Never, and When login information is not specified. If I select always, the login prompt appears everytime the user selects a different form (and many times for forms with more than one table).

I would like to present the user with a form where they can enter their userid and password once, and then my application can use this information whenever it needs to connect.

Any ideas on how this can be done?

Jeff