Access 2003 max rows

[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

 

[Sylvain Lafontaine]

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)

 

[rentgeeen]

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....

 

[Sylvain Lafontaine]

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)

 

[rentgeeen]

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....

 

[Sylvain Lafontaine]

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)

 

[rentgeeen]

U mean with the SQL Studio EXPRESS?

I can see all records, so in Access there must be something to turn on...

here I post a link with screenshots:

http://radekvalachovic.com/access/

all set to 0 or 20000 and the status line records is only 10 000....

 

[Sylvain Lafontaine]

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)

 

[rentgeeen]

where can I get that profiler and how to test it?

 

[Bob McClellan]

go to the DATA tab on the FORM properties and set the max there to 0 ( or
20000 If you prefer )

 

[Bob McClellan]

...meant to say.. as Sylvain suggested in his 1st reply.

 

[rentgeeen]

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?

 

[Bob McClellan]

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?

 

[rentgeeen]

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

 

[Ben Johnson]

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