If you click on the downloads section, you will find a handful of Add-ons free to download. Half are accessible as Access 2000 files. All are useful for Access 97. This article teaches the very basics of using Visual Basic and ADO to connect to a Microsoft Access database. Here is a handful of SQL in Access tips that will blast you with some wholesome information.
Explanations here solve performance issues, authoring queries and more.
Total Visual Agent is a database maintenance and scheduling tool for Microsoft Access, Office, and Visual Basic. DevX Microsoft Access can extract items from foreign databases using ODBC, but there has always been a problem doing the same with Informix data. In this 10-minute solution, the author goes over how to pull data from Informix to MS Access. This intermediate article discusses how to create a Password Protected Access database, and then details how to open it, and interact with it, all from within Visual Basic. Unfortunately, Visual Basic doesn't provide native support for interaction with Access 2000 Databases.