C++ & MS Access

[utnah]

Creating a programme for a small professional firm, that will require a minimum of 30,000 records for existing clients with the capacity to cope with further records.

1. Whats the limit on the number of records, or is it infinte (save for diskspace limit)???
2. How well does MS Access (particularly 2000) cope with being controlled by C++?
3. Are there better/easier database applications to use for this purpose - i.e. that have an infinite record count??

 

[evalesthy]

Access 2000 published specs:

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

That's a general overview. Access is very flexible - but does require some knowledge to use it to it's full potential. As far as "controlled by C++" what do you mean - are you going to feed Access data from another application?

If you post more specific questions I'm sure people here will be glad to respond.

 

[CajunCenturion]

Access is not really controlled by the language the front-end is written in. The database control comes from the data model (ADO, DAO) and data engine (JET). You should not have any difficulties using the ADO data model, as they are ActiveX controls, as a layer between the C++ front-end and the Access backend.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein