Hur många poster kan man ha i access?

2Mb?

http://www.experts-exchange.com/Databases/MS_Access/Q_21024260.html

Ok, vet kanske borde bytas ut mot tror =)

Dock så måste man registrera sig för att få svar där. Ingen som vet svaret?

Tack /Erik

Jag är inte registrerad. För mig räcker det bra om jag scrollar... Funkar inte det för dig?

Jag besökte sidan igen, och då fick jag inte heller läsa. Jag citerar lite av svaren:

Microsoft 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
Number of indexes in a table 32
Number of fields in an index 10
Number of characters in a validation message 255
Number of characters in a validation rule 2,048
Number of characters in a table or field description 255
Number of characters in a record (excluding Memo and OLE Object fields) 2,000
Number of characters in a field property setting 255

The following are general Access limitations:

Microsoft Access database general 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 (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

och mest intressant för dig:

1. No row limit, total .mdb size is limited by 2Gb

mvh

Tack för det!

Men detta berättar väl inte hur många rader man kan ha? Finns det kanske inga begränsningar där?

Läs det sista, pyttiga citatet.

mvh

Tack!