>I used to hide all data manipulation in a DLL (which is responsible of the connection). The main application is not aware of the database.
>

Do you use VB's Data Source Classes (by setting the DataSourceBehavior attribute of the class to 1-vbDataSource)? Is this the best approach?