Time Error '3021' eof or bof sometimes but not all teh time

[johnnyv]

hello all
here is my problem I am testing a VB/Acess app in 98, 2000, xp home and pro.
My app will write as record out to a table when testing in any OS.
I then run a sql statement to pull back the record
ie select * where [name] = 'john'

the reocrd containing the name john is present on all PC's with all OS's but when I execute this sql statement on the XP Pro or the win 98 OS boxes I get the following error
'either EOF or BOF is true or record has been deleted'

when I execute the same code on w2000 or XP home I do not get any error and the record is returned.

If I open the table in Access in XP pro or win98 and execute the same sql statement from the the query screen it will return the reocrd

what is going on?

not a very good description I admit but any suggestions as yo how I can debug this?

 

[petermeachem]

It's not the old write cache 5 second delay is it. There should be a reference to it somewhere on this site.

http://www.accuflight.com

http://www.lettersdirect.co.uk

http://www.ourhouseinportugal.co.uk/

 

[SonOfEmidec1100]

I recall an issue from way back with the Jet workspace writes in that they could not be seen immediately by apps other than the one doing the update.

For more info Refer to MSDN articles on

CommitTrans dbForceOSFlush
DBEngine.Idle dbRefreshCache