Access 2003 max rows

  • Thread starter Thread starter rentgeeen
  • Start date Start date
R

rentgeeen

hi

I have SQL database, I made a ADP access 2003 project file to connect it to
SQL DB, I am using it like 2-3 years to update all records in all tables, but
now I got a problem, I add more records and in 1 table rows are more than
10000, the is like 10025, but I cant see records after 10001, so first thing
what I did was went to
Tools>Options>Advanced Tab and set DEFAULT MAX RECORDS to 20 000, DEfault
file format set to both Access 2000 & Access 2002-2003 and still I can see
10000 rows but no further. So I set DEFAULT MAX RECORDS to 0 and still no
change, so how can I see all records in the table exceeding 10000 rows?

Thanks
 
Each form also have their own Max Records setting. You have to change it as
well. Also, you should learn how to restrict the number of returned records
by applying some kind of WHERE condition or a filter; otherwise, you might
run into locking problem with the other users of the database.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
Hi

Where can I find form max rows? I am not using forms at all...

Restrict returned records? Nobody is connected to database (SQL) except me
when editing it,

1 table has more than 10 000 records, what i want is when I open it, I want
to browse and scroll and see all records in that table ( counter is showing
me 10 000 records and I know there are more), I can see them all in Microsoft
SQL Studio Express but not in Access.....there must be a way I dont believe
that access allows to see only 10 000 records in 1 table only....
 
I've just make a quick test here with ADP 2003 and SQL-2000 and I have no
problem opening a table directly in datasheet view with more than 10000
records when the option is set to 0 or to 20000.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
I set max rows to 20 000 and 0, nothing changed, I can see only those 10000,

2nd thing if I make a query and try to query those behind 10 000 the result
is 0, so the thing is access is ignoring those beahind 10000....
 
Hum, very strange. What are you seeing if you take a look with the
SQL-Server Profiler?

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
No, I really mean with the SQL-Server Profiler, in order to see what
commands Access is sending to SQL-Server. However, at the moment, I don't
know if the Profiler is available with the Express Edition.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)
 
go to the DATA tab on the FORM properties and set the max there to 0 ( or
20000 If you prefer )
 
Where is the FORM properties, there only properties:

Tools>Options

I am not using any FORMS in my database. so where can I find any form
properties?
 
My mistake.
I thought you were using a form.
... if you double click on the table and it opens only 10k rows,
can you click the button on the bottom, next to the record selector,
to set the maximum record count?
 
Ok, now it works I clicked the last button on the records bar ans it asked me
how many records to see,

that's weird it doesnt work from the Tolls>Options menu...

Thanks a lot
 
rentgeeen said:
hi

I have SQL database, I made a ADP access 2003 project file to connect it
to
SQL DB, I am using it like 2-3 years to update all records in all tables,
but
now I got a problem, I add more records and in 1 table rows are more than
10000, the is like 10025, but I cant see records after 10001, so first
thing
what I did was went to
Tools>Options>Advanced Tab and set DEFAULT MAX RECORDS to 20 000, DEfault
file format set to both Access 2000 & Access 2002-2003 and still I can see
10000 rows but no further. So I set DEFAULT MAX RECORDS to 0 and still no
change, so how can I see all records in the table exceeding 10000 rows?

Thanks
Click to expand...
 
Back
Top