The file has to be a part of the solution in order to be published with the application. You don't say if both projects are in the same solution. Are they?
You also don't say why it bombs on launch after install, but I would guess it has something to do with where you are deploying the sdf file, and the connection string you are using to access it.
RobinDotNet
Click here to visit my ClickOnce blog!