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]