Here are the facts.
Tools:
MS SQL 2012 Express
MS SQL 2005 Native Driver (because not all of our computers are up to date obviously)
MS Access 2010.
This is an Access db with a default form that calls an ODBC recordsource.
My File DSN works OK when I connect to tables using the default dbo schema. It bring the MS SQL Server dialog box.
If I try to connect to tables in a different schema (with all public privileges denied), it will raise an error message but my problem is that it will NOT prompt the normal log in dialog box. After the error message, there is nothing.
If I use my Windows profile as identification with sa privilege, again it will just go through (no error) but no log in dialog box whatsoever.
How do make sure that the dialog box is always present?