Hiya Denise ---
Sounds like you need to play around with the ODBC drivers a bit more and customize it at the ODBC level from Windows System Settings.
>I'm using "store sqlconnect("cne_data", "", "") to db" to open my connection to an Access mdb. Whenever this line of code is hit the first thing that pops up is a selection box for the user to select which ODBC connection they want. I just said which one it is (cne_data) in my sqlconnect statemnt, so why is this coming up?
>
>Also, it doesn't appear to make any difference whether I fill in the user name and password in the second box that comes up, the login box, or not. I still get approved to go on and access the database. What do I need to do to make this more secure?
>
>I've got a login screen for the application that immediately follows this. Only the users listed in my users table can get to it. Maybe I should just get rid of all this ODBC signon stuff altogether?
>
>Thanks.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05