I'm going to be building a commercial app using VB6. As far as the database is concerned - I'm not sure what the best choice would be - MSDE or Access2002.

My preference would be MSDE - simply because I've done a fair bit of SQL Server work lately. However, I'm not sure what that means for a distributed app - i.e. is the MSDE install (as part of an App install package) relatively painless to configure?

Any advice would be appreciated.