What are the capabilities of Access?

Hi Steve:

Maybe you or anybody else can help me.

I am using MSAccess 2003 as a front end to view the database tables of an
online MS SQL Server application. I know from the application's
administrative interface that I have over 13,000 records in the particular
table I'm wanting to see, but only 10,000 show up in Access.

From the discussion below I see that MSA supports hundreds of thousdands of
rows. Could you advise why I might only be seeing EXACTLY 10,000?

Thank you.

"Steve Schapel" wrote:

Jenny,

I agree with John here. You need to work out whether you need a
spreadsheet or a database. If it is database functionality that you
need, then Access is the way to go. If it turns out that it is actually
spreadsheet functionality that you need, something to take into account
is that Excel 2007 is just around the corner, with provision for a
million rows per worksheet.

--
Steve Schapel, Microsoft Access MVP

John Vinson wrote:

Access is emphatically *not* Excel on Steroids. Excel is a
spreadsheet, the best of the genre; Access is a relational database.
THEY ARE DIFFERENT and require different logic and different design.

Harry Cederbaum Harry wrote:

From the discussion below I see that MSA supports hundreds of thousdands of
rows. Could you advise why I might only be seeing EXACTLY 10,000?

Access will only fetch the first 10,000 records by default when in
datasheet view. What happens when you move to the bottom of the
datasheet view and Page Down? I suspect you'll see an additional
10,000 (or fewer) records.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

no this is the OPTIONAL record limit thing in ADP


a) in the record navigation bar-- the button all the way to the right will
let you choose a different record count for a particular table / form /
query

b) you can set the default (which I believe also resets this values for
existing forms and tables)

c) you can do this programmatically in SQL Server 'SET ROWCOUNT 20000' if
you want




"Tony Toews [MVP]" wrote in message
...
Harry Cederbaum Harry wrote:

From the discussion below I see that MSA supports hundreds of thousdands
of
rows. Could you advise why I might only be seeing EXACTLY 10,000?

Access will only fetch the first 10,000 records by default when in
datasheet view. What happens when you move to the bottom of the
datasheet view and Page Down? I suspect you'll see an additional
10,000 (or fewer) records.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm