This is one of those little gems I wished I known about a long time ago.
http://blogs.msdn.com/b/smartclientdata/archive/2005/08/26/456886.aspx
The DataDirectory macro allows you to specify what amounts to an application relative path to your .mdb files (for SQL Express, on ASP.NET and smart client deployments).