In my case, the DB is created by the older version of application and now the new version of application is installed and End user has option to see old data with selecting old version of DB so its completely on end user wish to choose the location for DB. And also new tables in DB are created to new version of application, on select of old DB, application has to create those tables in OLD DB also to synch. Application is successfully executing select query on UAC-ON however while executing DDL and DML it is throwing "Unable to open Database".
Thanks, Preeti -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Sereda Sent: Monday, July 19, 2010 3:15 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON I suspect the permissions set on DB file allow only Administrators to change it; and that requires escalation to Admin rights under UAC. It's likely that your DB file is located in C:\Program Files\yourapp. As a solution, you could relax permissions on the DB file upon installation, or, better, keep the file under C:\Users\currentUser\AppData\Roaming\yourapp -- Igor -- View this message in context: http://old.nabble.com/%22Unable-to-Open-DB%22-on-Win-7---Vista-%2864-bit t%29-on-UAC--ON-tp29202752p29202990.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
