Try to launch your appliztion with "Run As Administrator"(right click on exe -> Run As..). Note: Take care about fields information for old DB and new DB while opening tables(backward compatibility). For ex: old DB might have x number of fields and new DB might have y number fields where x is not equal to y but x and y greater than 0.
Regards, Durga. On Tue, Jul 20, 2010 at 1:58 PM, <preeti.yad...@wipro.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users