Hi there.
I have an Access2000 database with local and linked tables. The linked table source is a foxpro database and all data is static. No other users have access to either database but when I execute queries that join the local tables to the linked tables, I get inconsistent and incorrect results (incorrect because it only returns a portion of the final result set and inconsistent because I get anywhere between 80-98% of the records on each execution). Its as if Access is reaching an ODBC timeout limit and returning only the subset of data that it was able to grab before timing out. Am I seeing things? X-) The linked tables don't even have that many records - (maybe 30,000 or so). Has anyone else experienced this and if so, how did you resolve the problem??
I have an Access2000 database with local and linked tables. The linked table source is a foxpro database and all data is static. No other users have access to either database but when I execute queries that join the local tables to the linked tables, I get inconsistent and incorrect results (incorrect because it only returns a portion of the final result set and inconsistent because I get anywhere between 80-98% of the records on each execution). Its as if Access is reaching an ODBC timeout limit and returning only the subset of data that it was able to grab before timing out. Am I seeing things? X-) The linked tables don't even have that many records - (maybe 30,000 or so). Has anyone else experienced this and if so, how did you resolve the problem??
