Deploying VB2008 Application?

Hello:
I am new to VS2008. I have created a very simple database (SQL Compact) program just for learning purpose. I have added the database to my project and it is located c:\sqlsample.sdf.

When I publish my program I can see that the database is included but it will not copy it over to the clients PC. My program installs OK. but it always gives me an error that database can't be found. If I manually copy the database over from the install disk to the correct location everything works just fine.

Is there something I am missing?

Also what is everyone using as there setup creator?

When I was programming with VB6 I used INNO.

Thanks

Anybody with any Ideas?