Hvor stor kan en database være/blive

Den kan sagtens blive meget stor...
Det kommer an på din server..

Jeg har selv indtil flere databaser der har over 10000 poster liggende i de forskellige tabeller, og selvom det er access databaser så giver det ikke nogen problemer.

Mine databaser kan godt fylde omkring 10 mb uden problemer..
Det kan dog give lidt forlængede svartider.

Håber at dette hjælper (kan ikke huske hvor jeg har det fra):

Access Database Capabilities and Limitations

Access databases have considerable scaleability, vastly in excess of many small business database needs. Access is capable of storing tables up to 2 Gigabytes However, because your database can include linked tables in other files, its total size is limited only by your machines available storage capacity. For more detailed program specifications please see below:

Access database general program specifications

Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules 1,000
Number of concurrent users 255

Access database table specifications

Attribute Maximum
Number of characters in a table name 64
Number of characters in a field name 64
Number of fields in a table 255
Number of open tables 2048. The actual number may be less because of tables open internally by Microsoft Access.
Table size 1 Gigabyte
Number of characters in a Text field 255
Number of characters in a Memo field 65,535 when entering data through the user interface; 1 gigabyte when entering data programmatically.
Size of an OLE Object field 1 Gigabyte

Access database query specifications

Attribute Maximum
Number of enforced relationships 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
Number of tables in a query 32
Number of fields in a recordset 255
Recordset size 1 Gigabyte

Form and report specifications

Attribute Maximum
Number of characters in a label 2048
Number of characters in a text box 65,535
Number of printed pages in a report 65,536