sqlite.open from installation path

[Canter]

I'm having a problem accessing an sqlite database under the following scenario:

The build is a single exe file, but I'm keeping the database file separate so that it can be modified (as opposed being in a temp file). I get the installation path from the registry, and use that plus the sqlite file name as the file paramater in the sqlite.open function. No errors are generated, but the database isn't accessed either. The only way I've been able to access it is to just build to a folder on the hard drive - and access it from paths such as _Sourcefolder, as opposed to the single exe.

Any ideas what I'm missing here? I don't understand why no errors are generated - the application acts as if it did read/write to the db - only it does neither.


Thanks for any suggestions.

[Canter]

I don't think it matters here, but just in case - I am running under 64 bit Vista.