S
Shawn
We are getting a system resources exceeded message on a query with a left
join between a local table (left) and odbc linked table (SQL Server) on a
machine running XP and Access 2003. When the join is changed to an inner
join, the query runs successfully. The net result difference is 4 records.
A machine running windows 2000 succesfully runs both queires. I have edited
the MaxLocksPerfile in regedit and Buffer size. Any thoughts?
join between a local table (left) and odbc linked table (SQL Server) on a
machine running XP and Access 2003. When the join is changed to an inner
join, the query runs successfully. The net result difference is 4 records.
A machine running windows 2000 succesfully runs both queires. I have edited
the MaxLocksPerfile in regedit and Buffer size. Any thoughts?