Click here to Skip to main content
15,440,308 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

Thanks to all who ever patiently answered all mine questions. With all your support i have successfully completed my First Phase of Project and started testing at client.

But, I got a problem. Mine is a C# based Windows Application and DB also resides in Local machine(i.e. in Programfiles\Applicaion\Data). Every thing is working fine. All of a sudden i got an error showing below. C# application is trying to create a .tmp file. I do not have any clue as from application i did not try to write/Update any data into DB or local files. Why C# application is trying to create a .tmp file and raises error i dont understand. Error Screen shot attached. By the way I am using DB Sql Compact 4.0

Shared album - Iam Lucky - Google Photos[^]

Thanks & Regards

What I have tried:

I am clue less here So, i did not try any thing.
Updated 14-Oct-16 2:17am

1 solution

Here's a reference for you:
Temporary Databases[^]

The bottom line is that SQL Compact will use temporary files even for queries.

If you're running the database with a user account (which might not have write permissions to Program Files), you might want to change the database location to a directory where users can access, such as the user's AppData folder.
Share this answer
Charles Shob 14-Oct-16 9:54am    
Thanks looks like Apt Answer.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900