Different Result on query ?

[=C-Black=]

Hi All,
My database was divided into frontend and backend. However for the same
copy of the frontend database using in the different client computer in my
company the query return different result. All the computer in my company
is using Access 2K. And there is the code

Dim rst As New Adodb.RecordSet, strSQL As String
....
....
strSQL = "Select Top 1 RCNNo From dbInfo " & _
"Where ((RCNNo) Like '012-RCN-####') " & _
"Order By RCNNo DESC;"
rst.Open strSQL, CurrentProject.Connection

If rst.BOF = True And rst.EOF = True Then
Define_ID <--- Another Function
Else
Me.RCNNo = rst.Fields("RCNNo")
End If
.....
....

For the same code above and doing same Query, some of computer was error
because of either EOF or BOF is True. But other computer is work well. I
don't understand why it will happen. Would anyone of you help me slove this
problem. Thank you

 

[M.L. Sco Scofield]

I've seen this problem before. It has been caused by not having *all* of the latest updates installed on *all* of the computers.

The first thing to do is make sure that *all* of the computers:

1 - Have the latest Windows service pack installed. See http://windowsupdate.microsoft.com

2 - Have the latest Office service pack installed. See http://office.microsoft.com/productupdates

3 - Have the latest Jet service pack installed. (Depending on which version of Windows you are using, this may have already been
installed with the latest Windows service pack.) See http://support.microsoft.com/default.aspx?scid=kb;EN-US;239114

Also, take a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;300216.

*After* you have installed *all* of the updates on *all* of the computers, post back if your problem still exists.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com