Dear Friends,
I have a problem on using MS Access for database management. VB has a lot of choices and I feel confused.
You know, VB has a visual data manager but it can't open those MS Access 2000 mdb files but can open 97. Can later service pack fix this problem?
In visual data manager, I can build several indexes for speed up searching or sorting. Suppose I have fields called ticker, date, name, ... , etc
I can build indexes:
ticker
ticker;+date
ticker;-date
How can I build several indexes in Access 2000?
If the user has 2000 rather 97, I use Jet 4.0 for ADO accessing a 97 mdb. is it OK?
If I distribute 2000 mdb files, the user having 97 software in their computers will find backward incompatiblity. But if I use 97, I am afriad it is not powerful enough. Which you would suggest me to use 97 or 2000?
If I have 1 miliion records in the mdb, then will the speed very low (suppose normal computer Pentimum 3 500 or above)?
