Re: Problem with FIND command and 2000 machine

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: danbaran (anonymous_at_discussions.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 13:31:14 -0800

The machines are 3 XP pros and 2 2000's connected to a 2003 server that is acting as a data repository. the error states something like either bof or eof has been reached.

Set db = New Connection
  db.CursorLocation = adUseClient
' db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source='" & G_Sdatabasename & "'"
  db.Open "PROVIDER=MSDataShape;Data PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source='" & G_Sdatabasename & "'"

  Set adoPrimaryRS = New Recordset
  adoPrimaryRS.Open "select SupplierID,.....

.................ERROR CODE FOR 2000 MACHINES....................

    cmdUpdatevendor.Visible = False
    If Combo1.Text > "" Then
    
        adoPrimaryRS.Find "SupplierName = '" & Combo1.Text & "'", , adSearchForward, 1
        DoEvents
        MsgBox "" & adoPrimaryRS!address
        If adoPrimaryRS.EOF = False Then

Before I left the office i tried it on an ME machine same issue.

Relevant Pages

  • Re: Application Role - aduseclient
    ... The only thing I can think of is if the recordset is opening ... It happens in ADO sometimes where a connection is ... >Set bestelcon = New Connection ... >As long as there is no "aduseclient or aduseclientbatch", ...
    (microsoft.public.sqlserver.security)
  • Help on using Shape
    ... Dim db As Connection ... db.CursorLocation = adUseClient ... Set adoPrimaryRS = New Recordset ...
    (microsoft.public.vb.database.ado)
  • Re: Cannot update a disconnected (and then re-connected) ADO recordset bound to Access 2003 form
    ... opening a new connection object that explicitly has client-side cursors ... adCursorLocation set to adUseClient. ... When updating the disconnected recordset ...
    (microsoft.public.access.formscoding)
  • Re: DataSource class help
    ... MSDN article called "How To Extract Child Recordsets from Shaped ... Recordset" - Q191744, which is along the lines of what I am trying to do. ... > 1) Don't open an ADO Connection in the Class_Initialize event. ... > Set adoPrimaryRS = New ADODB.Recordset, ...
    (microsoft.public.vb.general.discussion)
  • Re: Persisted Recordsets
    ... Your comment about the CursorLocation property was the key to this. ... application is opened again and no connection can be established with the SQL Server, that it will load the recordsets from disk. ... How can I either store the base table information during the write to disk, or add it to the recordset after it has been read from ... > Connection to adUseClient. ...
    (microsoft.public.data.ado)