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". Please guide us on this issue. Please let me know if it is not clear to you all. Thanks, Preeti ________________________________ From: Preeti Yadav (WT01 - Healthcare and Services) Sent: Monday, July 19, 2010 1:47 PM To: 'sqlite-users@sqlite.org' Subject: "Unable to Open DB" on Win-7 & Vista (64 bitt) on UAC -ON Hello Team, I am using SQLite DB for java/Swings based desktop application. We are facing below issue on Win-7 & Vista (64 bit) Operating System only on UAC -ON (User access Control). Current version of application is unable to do any DDL/ DML on DB Created by older version of application on Win-7 & Vista (64 bit) Operating Systems only on UAC -ON (User access Control). We found that DB is throwing "Unable to Open DB". Everything is working perfectly if we set UAC to Never Notify. We do not have any problems with other OS like Win-xp, Mac, etc. We request you to please guide us on this issue. Please let me know if you need more information. Thanks in advance for your kind help!! Warm Regards, Preeti 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