| | |
|
|
|
a elemental question |
|---|
| message from knit on 3 Jun 2004 |
can I know from you how many records one access database can have? I have
over 10,000 pieces of records, can I use Access to manage these records?
|
| Allen Browne replied to knit on 3 Jun 2004 |
10,000 piece of cake
100,000 no problem
1,000,000 Possible, but if you see it coming before you begin, you may
want to move to a bigger database.
|
| =?Utf-8?B?VG9t?= replied to Allen Browne on 3 Jun 2004 |
Well ... 1,000,000 is a bit expected less !!!
|
| John Vinson replied to knit on 03 Jun 2004 |
You're limited to 2 billion bytes in the entire .mdb file.
The largest production Access database of which I am aware has some
50,000,000 records in its largest (of many) table. I'd have moved to
SQL/Server before it got that big but the user seems happy with it.
John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public
|
| anonymous replied to knit on 3 Jun 2004 |
can have? I have
these records?
so 10 000 records is fine.
Leon
|
|
Archived message: a elemental question (Microsoft Access Database)
