>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

You can create some app object properties .connuserid, .connpassword, reset their values in your custom form, and use DBSETPROP() to set connection properties before each SQLConnect call.