Number of records

[Guest]

Hi
I created an access 2000 db where I have one table that’s about 200
characters in size and I have 2 questions:
1) How many records can one save in a table this size? What determines the
number of records?
2) I have two continuous form that display sections of this table. Is there
a limit to the number of records that can be displayed in a continuous form?
Before I spend a lot of time entering my data I would like to know if this
is going to work.
Thanks,

 

[tina]

open Access Help and do a search on "specifications".

hth

 

[ruralguy via AccessMonster.com]

Go into Access Help and look up Specifications. Your answers are there.

 

[Joseph Meehan]

Hi
I created an access 2000 db where I have one table that's about 200
characters in size and I have 2 questions:
1) How many records can one save in a table this size? What
determines the number of records?
2) I have two continuous form that display sections of this table.
Is there a limit to the number of records that can be displayed in a
continuous form? Before I spend a lot of time entering my data I
would like to know if this is going to work.
Thanks,

There is no direct number of records. It depends on many things. The
primary limitation is the max size of the file which depends on the version
of Access you have, I believe yours is limited to 1 gig, which means many
many records. A few hundred thousand should be easy for it.

 

[John Vinson]

Hi
I created an access 2000 db where I have one table that’s about 200
characters in size and I have 2 questions:
1) How many records can one save in a table this size? What determines the
number of records?

If there's nothing else in your database except this table, about
10,000,000 records. The limit is that a single .mdb file cannot exceed
two gigabytes.

2) I have two continuous form that display sections of this table. Is there
a limit to the number of records that can be displayed in a continuous form?

There is no limit. Of course, there is a limit on the size of your
screen, the fonts available, and your users' eyesight acuity to how
many records you can display on the screen simultaneously, but that's
why there are scrollbars.

Before I spend a lot of time entering my data I would like to know if this
is going to work.

If you're worried about whether you can display data from your tables
after the data is entered... don't. You can. That's what Access is
for.

John W. Vinson[MVP]