Bert,Well my guess (from reading the previous emails) is that is neither a COM or a SQLite problem - basically a lack of understanding re users, services and nt securiity
It is a COM-related problem, not a SQLITE problem
I can now tell you that it IS a sqlite problem NOT a COM problem. Sqlite is trying to create its temporary database at some location (which I'm not sure where) and it failed. I have found that you can force sqlite to store its temporary database in memory. Once I have done that, the problem has gone!
If your com server is running as a normal service (not interactive or logged on) then it has no user profile. Which means it cannot access any network directores etc, also it will have no user enviroment settings such as temporary directories it can access. This why setting the temp dir to memory works.
The easy solutuin is to have the service logon as a user, either an existing one or create a user account for it.
Alternatively you could create a temp directory thats globaly read/writable and have the service use that as its temp dir.
