If you’re working in Microsoft Access 97, you can use either the CurrentDb function or the DBEngine(0)(0) syntax to return a reference to the database that is currently open in the Microsoft Access user interface. The CurrentDb function differs from the DBEngine(0)(0) syntax in that it creates another instance of the current database and returns a reference to that instance, and it refreshes all the collections in the current database. On the other hand, the DBEngine(0)(0) syntax doesn’t refresh any collections, so it may perform faster.
If you switch from using the CurrentDb function to the DBEngine(0)(0) syntax, make sure that your code doesn’t depend on any collections being refreshed. If it does, you can refresh these individual collections separately.
See Also For more information on using the CurrentDb function and DBEngine(0)(0) syntax, see Chapter 2, “Introducing Data Access Objects jb2Introducing_Data_Access_Objects.”