So I was reading this http://www.packtpub.com/article/conn...-visual-studio to learn about database crap as my apps are needing databases. the part that confuses me, if the path it uses
Code:
Dim compactStr As String = _
"Data Source=I:\Folder\Folder2\Projects\App1 Platform\Compact\Compact\mydb_Apps.sdf"
What or how does this work when you publish your app and give it out to people to use. Won't the database string be the above address for them too? in that case it is not going to work, right? Is there a way to configure these strings programmatically so they use address of the application?

i am only getting started on the whole database thing and if i can get some pointers and advice in terms of how i should go about setting them up. would be great.

thanks