[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 940
  • Last Modified:

BOF/EOF error w/ADO VB6.0

I have a very simple Access db with full share rights. I am using a Find method to locate a specific record then write this to the UI.  I can only locate a few records before I get an BOF or EOF error message.  When I try to handle this by capturing the error and saying movefirst or movelast (or even movenext and moveprevious) this does not seem to help.  In either case my program seems to get stuck on the first or last record and will not find any more records.  What am I doing wrong?
Thanks.  
0
gcassel
Asked:
gcassel
1 Solution
 
mark2150Commented:
Lets see your code. You may have your search too restrictive.

M

0
 
Renato102098Commented:
It is more flexible use SQL for example
Select field1, field2, field3 from Table Where field1 = 'nnn' ... field2 like 'mmm&' .... order by field3 Asc ....
This is more quick if you set CursorLocation = adUseServer and you lost same benefit.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now