Where to get ADO 2.1 or higher?
I installed the Visual Studio, should it be ADO 2.1? How to check?
Where can I get the latest version? Pls advise, thanks.

>>>Aren't there any other user or apps in that database? How do you compact the database? I think you are using ADO, see this: http://support.microsoft.com/support/kb/articles/Q230/5/01.ASP
>>
>>I tried the suggested method from the web site, but hit error as follows:
>>
>>Could not find installable ISAM
>
>You need ADO 2.1 or higher.
>
>
>>
>>But I use the other method is OK as follows:
>>
>>DBEngine.CompactDatabase "c:\TTD.mdb", "c:\TTDComp.mdb", dbLangGeneral, _
>>dbVersion40, ";pwd=abc"
>>Kill "c:\TTD.mdb"
>>Name "c:TTDComp.mdb" As "c:\TTD.mdb"
>>
>>Any difference between these two methods, which is better one? Thanks.
>
>Both have the same result. If you use ADO, I prefer the first way. If you use DAO, I prefer the DBEngine way.