Changing Maxlocksperfile Temporarily and then Permanently

  • Thread starter Thread starter becker
  • Start date Start date
B

becker

I am using Access 2000.

I have a table with 70,000 names and addresses. When I try to access the
table through a combo box, it will only go to (w)s. For instance, if I want
to search for a particular name of which I don't know, and I key in a (w), it
will bring up the first name that starts with a (w) but the drop down box
won't move which in turn won't let me see the rest of the (w)s. The upper
part of the alphabet works fine.

I feel like it is in my Maxlocksperfile setting but I can't find any
information on the setting. Years ago when I developed this database I set
it, but now I cannot find any of my notes.

Does anyone have any experience with this setting or can point me in a
direction?

Thanks.
 
A combobox is limited to 64K records (65535?). What you need to do is limit
the records displayed in the combobox.

There are various methods for doing this. One method is to have the letters
of the alphabet available and when the user clicks on one of the letters, the
list is populated with records beginning with that letter.

A second method is to start with NO records in the combobox. When the user
types the first letter (or letters) that triggers a routine that updates the
source of the combobox.

Private Sub Combo6_Change()
If Len(Me.Combo6.Text & "") = 1 Then
Me.Combo6.RowSource = "SELECT Fid, fSubject" & _
" FROM FAQ " & _
" WHERE fSubject like """ & Me.Combo6.Text & "*"""
Me.Combo6.Dropdown
End If
End Sub

You could modify that to make the change to the rowsource when 2 or less
characters or exactly two characters were entered.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
John Spencer.......

Thank you for responding so quickly.

Now that you mention it I have read that somewhere. I can purge my table
and solve the problem temporarily.

Is this limitation the same in Access 2007? I probably should have upgraded
before now it's such a neat program and works so well.

Thanks again.
-
becker
 
As far as I know, the limit is the same.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top