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)


"rentgeeen" <(E-Mail Removed)> wrote in message
news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
> 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

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
newsFD6BE7F-D72B-4395-8329-(E-Mail Removed)...
> 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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
>> > 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
>>
>>
>>

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> newsFD6BE7F-D72B-4395-8329-(E-Mail Removed)...
> > 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" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:779D95A2-5CB0-4820-8849-(E-Mail Removed)...
>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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> newsFD6BE7F-D72B-4395-8329-(E-Mail Removed)...
>> > 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" wrote:
>> >
>> >> 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" <(E-Mail Removed)> wrote in message
>> >> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>

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" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:779D95A2-5CB0-4820-8849-(E-Mail Removed)...
> >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" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> newsFD6BE7F-D72B-4395-8329-(E-Mail Removed)...
> >> > 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" wrote:
> >> >
> >> >> 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" <(E-Mail Removed)> wrote in message
> >> >> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
> >> >> > 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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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" <(E-Mail Removed)> wrote in message
news:CD930DD2-13A4-483A-A202-(E-Mail Removed)...
>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" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:779D95A2-5CB0-4820-8849-(E-Mail Removed)...
>> >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" wrote:
>> >
>> >> 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" <(E-Mail Removed)> wrote in message
>> >> newsFD6BE7F-D72B-4395-8329-(E-Mail Removed)...
>> >> > 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" wrote:
>> >> >
>> >> >> 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" <(E-Mail Removed)> wrote in message
>> >> >> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
>> >> >> > 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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>

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

"Sylvain Lafontaine" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:CD930DD2-13A4-483A-A202-(E-Mail Removed)...
> >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" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:779D95A2-5CB0-4820-8849-(E-Mail Removed)...
> >> >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" wrote:
> >> >
> >> >> 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" <(E-Mail Removed)> wrote in message
> >> >> newsFD6BE7F-D72B-4395-8329-(E-Mail Removed)...
> >> >> > 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" wrote:
> >> >> >
> >> >> >> 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" <(E-Mail Removed)> wrote in message
> >> >> >> news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
> >> >> >> > 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
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

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


"rentgeeen" <(E-Mail Removed)> wrote in message
news:FF984BCD-89EC-4B85-9B77-(E-Mail Removed)...
> 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