Error 3021 "Either BOF or EOF is True..."

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On one particular PC we get that message on the following line of code :

Me.Bookmark = rs.Bookmark

All other PC's, same code, same Access version do not get this error. If I
stop the code at this point and do a "Me.MoveFirst" then rerun the line, it
works.

Again, only on this PC does this happen. Any ideas ?
 
Follow up:

I added 2 DoEvents On Error, and Resume, and works. Any ideas as what is up
with this PC ? PC issue ? Network connection issue ?

Thanks
 
Add the following test:

if (not rs.EOF and not rs.BOF) then
Me.Bookmark = rs.Bookmark
end if

You may also want to add a test to make sure that rs is an object and is
opened; because if the OpenRecordset had failed for any reason, not
Recordset will be created (if you don't have created the recordset yourself)
or opened.

What version of Access are you using and on which version of Windows is this
happening?

If you have Win2003 with SP1 or are running Access 2002 on WinXP with SP2;
then this error is frequent when the method RecordsetClone is used in these
environments.
 
Hello Stuart:
You wrote in conference microsoft.public.access.adp.sqlserver on Wed, 11
May 2005 09:30:02 -0700:

S> On one particular PC we get that message on the following line of code :

S> Me.Bookmark = rs.Bookmark

S> All other PC's, same code, same Access version do not get this error.

one possibility: otjher pc's have different language.

another: different version of MDAC.


Vadim Rapp
 
Thanks,

I'll check into the MDAC, XP and Access versions next chance I get. I'm
betting that one of those are the issue.
 
Back
Top