Maximum Tables? Maximum Fields/Columns Per Record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I am very, very new to using Access, and I am currently scoping out what
tables, records and fields I will need for a new database. After reviewing
the postings - it does not appear to be a limit to the number of records in a
table. Is there a maximum number of tables I can include in a database? Is
there a maximum number of fields/columns I can include with a record? Thanks
in advance for any assistance.
 
Mximum # object (including tables) is 32,768

Max fields is 255, which is about 5 times more than most tables need except
in very unusual circumstances and applications

Max database size is 2Gb for Access 2000 and above

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Kevin3NF said:
Mximum # object (including tables) is 32,768

Max fields is 255, which is about 5 times more than most tables need except
in very unusual circumstances and applications

Max database size is 2Gb for Access 2000 and above
Click to expand...

I suppose you are just planning right now, trying to be sure that you
will not bump into unpleasant surprises. Something you might consider
doing as part of the effort is to set up some tentative Tables to
organize your data (and your thinking). I expect that you will find
that Access will do everything you need for right now, but that
eventually, if you run into millions of records and hundreds of Tables,
or you need to allow more than four persons to use the database
simultaneously, you'll find Access to be kind of limiting... at which
point you might want to migrate to SQL Server (which Microsoft claims is
quite easy to do, but I have no first-hand knowledge of that).

But for right now, whatever you do in Access will probably be fairly
easy to redo if it doesn't work well -- Access is pretty flexible. When
you've designed a few Tables and want to check that you've done the
design well, post another message here and someone will likely offer
some feedback on it.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Thank you Kevin for your assistance.

Kevin3NF said:
Mximum # object (including tables) is 32,768

Max fields is 255, which is about 5 times more than most tables need except
in very unusual circumstances and applications

Max database size is 2Gb for Access 2000 and above

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
Click to expand...
 
Vincent thanks a lot for your assistance.

Vincent Johns said:
I suppose you are just planning right now, trying to be sure that you
will not bump into unpleasant surprises. Something you might consider
doing as part of the effort is to set up some tentative Tables to
organize your data (and your thinking). I expect that you will find
that Access will do everything you need for right now, but that
eventually, if you run into millions of records and hundreds of Tables,
or you need to allow more than four persons to use the database
simultaneously, you'll find Access to be kind of limiting... at which
point you might want to migrate to SQL Server (which Microsoft claims is
quite easy to do, but I have no first-hand knowledge of that).

But for right now, whatever you do in Access will probably be fairly
easy to redo if it doesn't work well -- Access is pretty flexible. When
you've designed a few Tables and want to check that you've done the
design well, post another message here and someone will likely offer
some feedback on it.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
Click to expand...
 
DBS, Thank you I will try a search on "specs". I tried searching on tables,
records, etc and could not find the info.
 
DBS, Thank you I will try a search on "specs". I tried searching on tables,
records, etc and could not find the info.
Click to expand...

"Specifications" actually (though "specs" might work)

John W. Vinson[MVP]
 
Back
Top