To provide the proper environment, here it is:

lnHandle=SQLStringConnect(gaConnectionString[3])
SQLExec(lnHandle,'SELECT Video.Numero,Video.Active,Video.Date,Video.Notes_A,'+;
 'Video.Notes_F,Video.Running,Video.Title,Video.Type,Video.Amount,'+;
 'Master.FirstName,Master.LastName,Video.Language,Video.NoMaster,Video.NoMaster2,Video.NoMaster3,Video.NoMember '+;
 'FROM Video '+;
 'INNER JOIN Master ON Video.NoMaster=Master.Numero '+;
 'INNER JOIN Favorite ON Video.Numero=Favorite.NoVideo '+;
 'WHERE Favorite.AddUser='+ALLTRIM(STR(gnMember))+' ORDER BY Video.Title','test')

addjavascriptmessage(STR(RECCOUNT()))

a='SELECT Video.Numero,Video.Active,Video.Date,Video.Notes_A,'+;
 'Video.Notes_F,Video.Running,Video.Title,Video.Type,Video.Amount,'+;
 'Master.FirstName,Master.LastName,Video.Language,Video.NoMaster,Video.NoMaster2,Video.NoMaster3,Video.NoMember '+;
 'FROM Video '+;
 'INNER JOIN Master ON Video.NoMaster=Master.Numero '+;
 'INNER JOIN Favorite ON Video.Numero=Favorite.NoVideo '+;
 'WHERE Favorite.AddUser='+ALLTRIM(STR(gnMember))+' ORDER BY Video.Title into cursor temp1212'

&a
addjavascriptmessage(STR(_tally))

This is access after I have done an insert, and update or a delete in the table. So, we are just seconds away from the most recent change. In the test I am doing, I just inserted a record in the table Favorite by the use of SQLExec(). As you can see, the first SQL is done with SQLExec() and it returns 4. However, the second SQL is done locally and it returns 5. If I redo the same query for the next two minutes, sometimes the SQLExec() will return 4 and sometimes 5. But, the local SQL will always return 5, which is the correct number of records. After two minutes, the SQLExec() will always return the proper number of records, thus 5.

I have never seen anything like this. This is the lowest common denominator I can use to simulate the environment. Do you know what could be in cause here?