>Would it not be better served to set the security at the database-level?
>
>Regards,
>
>
>
>>I have a program that lets some users select one of 3 data connections to use for the program (e.g., test, pre-production and production). I get a connection error when setting security, even when the selected data connection is the default connection. If I modify the app.config file so there is only one data connection everything works just fine. Is this a bug or is there something else I need to do to get this to work?
>>Thanks.
Bill,
That works fine for some things but there are some things that users need to be able to control. That's where the MM security comes in. Thanks. Linda