Maximum Tables? Maximum Fields/Columns Per Record?

S

sharris

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

Kevin3NF

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
 
V

Vincent Johns

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

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

sharris

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
 
S

sharris

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

sharris

DBS, Thank you I will try a search on "specs". I tried searching on tables,
records, etc and could not find the info.
 
J

John Vinson

DBS, Thank you I will try a search on "specs". I tried searching on tables,
records, etc and could not find the info.

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

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top