SQL Server records not always found

[carole]

I'm using a basic find command in conjunction with a combo
box on a form to enable users to jump to a specific record
quickly. The SQL Server table contains less than 1000
records and is indexed (primary key) on the field I'm
searching in.

Recently, we imported several hundred records. On my
computer, the Find still works for all records. On other
users, it will work for the first 100, 200, 500 (depends
on the user) records; after that, it will act as if it
can't find the record and display the first record
instead. No error is generated.

I tried stepping through the code, but it worked OK when I
did that. I'm totally baffled and would appreciate any
help.

 

[Van T. Dinh]

Try stepping through the code using one of the problem
workstation with the normal user LogIn and see if you see
any differences.

HTH
Van T. Dinh
MVP (Access)

 

[Vadim Rapp]

c> On other users, it will work for the first 100,
c> 200, 500 (depends on the user) records; after that,
c> it will act as if it can't find the record and
c> display the first record instead. No error is
c> generated.

check what's the value of Maximum Records for the form on those
workstations. Access only looks among the records it has downloaded form the
server, which is limited by Maximum records.

Vadim

 

[LWiford]

Well, I'm glad I stumbled onto this posting. I am having a
similar problem. We are using an Access ADP as the front
end to a SQL 2000 database. The data will appear on the
form, but is uneditable. I changed the maximum records for
that form.

 

[Steve Jorgensen]

I have had a similar problem in the past. It seems that, beyond the issue
of the maximum number of records to be displayed, the form can also only
search records retrieved so far, and it appears to retrieve the records in
the background in batches of 50. The reason it works when you step through
is that this gives Access time to retrieve more rows before the Find is
executed.
I believe that what I had to do to get around this was to move to the last
row in the form's recordset (forcing all rows to be retrieved), then move
back to the first. After doing that, Find worked properly.

 

[carole]

I was on a normal user's computer when I stepped through
and everything worked fine.