When running a select query on a specific table on our SQL Server, any user modifying this table (contains order information) through our legacy system, causes the query to give you an ODBC time out error. Only after this change is committed and the record is released, will the query run. This query is only reading the table and not updating it.
I can however, open this table through access while maintenance is being done, and not have any problems. It's just when I run a query against this file!
What changes/enhancements need to be done so this query will run regardless of what the users are doing to this table?
I can however, open this table through access while maintenance is being done, and not have any problems. It's just when I run a query against this file!
What changes/enhancements need to be done so this query will run regardless of what the users are doing to this table?
