Detach, Move, Attach Again

I created a db in ssms; I detached it and moved it into a subdirectory of a vb app. Now sql server says the database does not exist. If I recreate the database in smss, I can run an INSERT INTO using that db as the destination. However, this only works if I keep it in the mssql data directory. How can I move it to the apps subdirectory so that it can be deployed with the app and still work? BTW, I also tried creating the databases in VS2005 with same results.

This is the connection string (tried this and non-express version with same results):

  strDbConn = "Provider=SQLNCLI;Data  Source=.SQLEXPRESS; AttachDbFilename=" & DbPath & ";User Instance=True;Trusted_Connection=Yes"

This is the sql statement:

  sqlCopyTable = "SELECT * INTO "
  sqlCopyTable = sqlCopyTable & CleanDbName & ".dbo." & CleanTableName
  sqlCopyTable = sqlCopyTable & " FROM " & RawTableName & ";"
  ConnectSQLExpress RawDbPath, "Source"
  ConnectSQLExpress CleanDbPath, "Destination"
  SourceDbConn.Execute sqlCopyTable