Does Access still limit #records in a table? Where do i fix?

  • Thread starter Thread starter DeniseG
  • Start date Start date
D

DeniseG

In Access2003, there was a field you could change for number of records
allowed in a table. I cannot find that in Access2007 but I am running a
query and the record number is alot less than it should be.

Where is the number of records limit (in a table) stored in Access2007?

Thanks, I appreciate your help.
 
Hi Denise,

I am not aware of any record limit in Access other than that imposed by
the 2GB database size limit. As you did not post the SQL of your query, I
can guess that there is probably one of two things going on: One, the query
is limiting the number of rows or two, your criteria is limiting the number
of rows in a way that you are not expecting. To check the first, while in
design view, right-click in the query and choose Properties. Make sure it is
showing the query's properties and not a table's or field's by clicking in
the blank background of the top part of the query. What does the Top Values
property show? If not "All" that is your problem. Change it to "All". To
test if your criteria is at fault, make a copy of the query and remove one of
the criteria. View the results. Keep doing this until you determine which
criteria is causing less records than you expect.

Good Luck!

Clifford Bass
 
Hi Clifford,

Thank you so much! I knew there was a way to check the query properties but
I forgot to use the blank space at the top of the query. I checked and the
Top field does say All so I will go back and test the query the second way.

I really appreciate your terrific response. Thanks again and have a great
day.

Denise
 
I believe that property was available only if you are using ADO (adb not mdb)
connectivity. And it controlled the number of records returned by a query, it
did not control the number of records in a table.

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