Access Limitations?


D

DTTODGG

Hello -
I'm brand new to access.
How big can the database be?
How many tables?
What other restrictions should I know about?
Thanks in advance
 
Ad

Advertisements

R

Rick B

As posted ALLLLL THE TIME. Use the help system. Type in "specifications".

Please search the previous posts in the newsgroup (and use the built-in help
files) before posting a new thread.
 
D

DTTODGG

Thank you.

Rick B said:
As posted ALLLLL THE TIME. Use the help system. Type in "specifications".

Please search the previous posts in the newsgroup (and use the built-in help
files) before posting a new thread.
 
J

John Vinson

Hello -
I'm brand new to access.
How big can the database be?
How many tables?
What other restrictions should I know about?
Thanks in advance
As suggested, Specifications in the online help is the place to look.
Quick answers: 2 GByte for a complete database (you can link multiple
databases together though); hundreds of tables, millions of rows.

With proper table normalization these two won't be a problem but they
do trip some people up: a single record can contain no more than 255
fields (an absurdly high limit, 30 fields is a very wide table) and no
more than 2000 characters. This last one is sneaky - you can create a
table with 100 fields each 255 characters wide, with no complaints -
UNTIL you actually fill a record with more than 2000 characters.

John W. Vinson[MVP]
 
Ad

Advertisements

L

Larry Linson

Please search the previous posts in the newsgroup (and use the built-in
And, for other good suggestions on effective use of newsgroups, see the FAQ
at http://www.mvps.org/access/netiquette.htm -- that is the FAQ for the
comp.databases.ms-access newsgroup, but the suggestions are good for any
technical Q & A newsgroup.

Larry Linson
Microsoft Access 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

Similar Threads

Access Limits? 2
Limited access to Access 1
Limitations of access 11
Access Limitations 1
Access limitations/suitablity 12
Sort limit in Access 4
Access Database size limitations 4
Limiting access to a command button 1

Top