MS Access MDB

[jamesnkk]

My client want me to develop Sales Inventory System + POS for his mini mart.
I was thinking using MS Access or VB 6, but I think mini mart could have many items to be store onto the tables. I am afraid Access's MDB might not be able to handle a large data per table (Nos of rows or Record per table). Does anyone know what is the max record per table ? or recommended total records per table, I mean would it cause problem or slowdown if data or record too large.
Does anyone have such an experience ?

[Rabbit]

Microsoft Access Specifications

[missinglinq]

The link Rabbit gave you is a very good one to bookmark, but the short answer is "No" there is no limit on the number of records per table. In answer to your general question, I see no reason why you'd have trouble developing such a database in Access. Having worked in both, Access would be my definate choice!

Linq ;0)>

[jamesnkk]

Microsoft Access Specifications

Thanks you for that wonderful informations

[jamesnkk]

The link Rabbit gave you is a very good one to bookmark, but the short answer is "No" there is no limit on the number of records per table. In answer to your general question, I see no reason why you'd have trouble developing such a database in Access. Having worked in both, Access would be my definate choice!

Linq ;0)>

Thank you for enlighten me