MS Access 97 and 2000 Incompatible!!!

[cantene]

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)?

[PatrickCorgan]

Do you have VB 6 SP5? if not see my signature to download it.

[cantene]

Originally posted by PatrickCorgan
Do you have VB 6 SP5? if not see my signature to download it.

Is it SP5 can open Access 2000 in Visual Data Manager?