Database Paths

[Denaes]

I think I'm missing something... I really hope I am.

 

I spent a long time writing an application - I used Database Explorer to connect to the database and I used the quick DataAdaptors and Datasets and dataconnections to create my application.

 

6 months down the line I realized my fatal error - the database was a fixed path! "C:\ApplicationName\Data\Data.mdb" - eek!

 

I understand the appeal of SQL Server as you don't have to worry about a location.

 

To fix my problem I had to recreate all of the controls via code and use Application.StartupPath to get the path.

 

But really, this is supposed to be a RAD for use with databases - what am I missing? How would you use the visual/quick controls and still have a professional application?

[Mister E]

Just make it so that the database's path is set as a configurable option. Store it in the registry or in a settings file.