Access Limitations?

[Guest]

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

 

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

 

[Guest]

Thank you.

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.

 

[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]

 

[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