I am hoping that someone can help me with two problems that I am having.
One, I have created an File DSN to allow multiple users to connect to the SQL server. I choose "Use Trusted Connection" as the way for them to log in, and made sure that I added all of the users. The issue is that everytime a user tries to connect to the SQL server database a box pops up and they have to choose "Use Trusted Connection". Is there a way to make a File DSN that uses the trusted connection, but doesn't require the user to select that option?
Two,
I have a table that has invoice history for multiple years, it is a big table. When I try to run queries from Access off of that table I often ger "ODBC Timeout Expired" errors. How do I change the amount of time before the database times out?
Thanks for all of the help,
sabloomer
One, I have created an File DSN to allow multiple users to connect to the SQL server. I choose "Use Trusted Connection" as the way for them to log in, and made sure that I added all of the users. The issue is that everytime a user tries to connect to the SQL server database a box pops up and they have to choose "Use Trusted Connection". Is there a way to make a File DSN that uses the trusted connection, but doesn't require the user to select that option?
Two,
I have a table that has invoice history for multiple years, it is a big table. When I try to run queries from Access off of that table I often ger "ODBC Timeout Expired" errors. How do I change the amount of time before the database times out?
Thanks for all of the help,
sabloomer