Select query results are inconsistent

  • Thread starter Thread starter gianni sacco
  • Start date Start date
G

gianni sacco

I have a simple query that's returning fluctuating
results. I.e., at different times it will return a
different number of records, although no changes have been
made to either the query or the tables it's hitting.

I can literally sit here and run the query two, three,
four, five times in a row and get a slightly different
number of records every time. Yikes!

The tables it's hitting are Visual FoxPro tables to which
the db has an ODBC connection.

Does anybody have a clue what could be happening? I'm at a
total loss.
 
gianni sacco said:
I have a simple query that's returning fluctuating
results. I.e., at different times it will return a
different number of records, although no changes have been
made to either the query or the tables it's hitting.

I can literally sit here and run the query two, three,
four, five times in a row and get a slightly different
number of records every time. Yikes!

The tables it's hitting are Visual FoxPro tables to which
the db has an ODBC connection.

Does anybody have a clue what could be happening? I'm at a
total loss.
Click to expand...

Hi Gianni,

Quite a while back, Arno had this same problem
and this is what worked for him:

*** quote ***
i found the problem in the odbc settings for visula foxpro databases. the
standard value for "BackgroundFetch" was set to "YES". when i set it to "NO"
all the results where ok!

i changed all the settings in the odbc-connection string but
"BackgroungFetch" was the one that solved the problem.

thank you for your help

arno
*** unquote ***

Worth a try to see if this also works for you.

Good luck,

Gary Walter
 
Ciao,

If you have a VBA function, its evaluation is deterministic (always
return the same result) or not ( like Now( ), which, evidently, return
something else at each call, so, it is not deterministic)? That is a
possible source that logically explains the described observation?


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top