Thanks for the reply guys.

The vb6 app does use DAO (cringe) and yes the access database would just become an additional layer between the vb6 app and the sql server....