I keep getting the "ODBC timed-out" error messages while running queries on a linked table, linked to a SQL Server table. I have set the time-out setting under Tools>Options>Advanced to the maximum, 300 sec, but it's not helping (it helps, but I still get the errors when I increase the size of the query return).
Is there anyone who can give me a general opinion on the effectiveness of MS Access as front-end for SQL server? Is VB better? Is there anything else that would be considered the "ultimate" front-end development tool for SQL Server?
Thanks for your help.
michael.kemp@gs.com
Is there anyone who can give me a general opinion on the effectiveness of MS Access as front-end for SQL server? Is VB better? Is there anything else that would be considered the "ultimate" front-end development tool for SQL Server?
Thanks for your help.
michael.kemp@gs.com