How do I structure my files so that I don't need to include the full file path?

[Alex Dransfield]

I am running my project from a USB drive and when I mount the drive, it's not always mounted at the same location.

I get the error message that my database cannot be found when I attempt to run the program.

connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12. 0;Data Source=\ExamsHelper\SysDB.accdb");

This is the location, but I get the error message that it cannot be found at C:\ExamsHelper\SysDB.accdb. This is not even where my project is located so I'm not sure why it is looking for it in C:\

Which one of these is sufficient?

[GaryTexmo]

Where is the executable located? It's running off the USB drive too? That should actually work, I've used relative paths like that before.

If you can't figure it out, see what is stored in Application.StartupPath. You can always use that to build your folder paths.

[Alex Dransfield]

All fixed, sorry! I forgot to change the question.

[GaryTexmo]

If by that you mean you solved it on your own, without my help, please post your solution and pick that as the best answer so people searching through the forums in the future get the correct information ;)

Thanks!

(And glad you got it figured out!)