I have recently purchased and installed the software SQLite Manager 4, now I am creating new SQLite3 database and whenever I try to create new table with 'xyz' name with any number of column, it gives me error stating "unable to open database file".

No other details is given on that part. I also searched for FAQ and other user manual, but did not succeed.

Please help me on this part.

Thank you.

  • How did you create the database file?
    – Gerry
    Mar 18 '13 at 10:41
  • On clicking new sqlite database.
    – Sarah
    Mar 18 '13 at 10:44

SQLite is a file-based database engine, and is therefor dependent on appropriate file permissions.

Check that the directory containing the database file is read-write-executable (rwx or octal 7) by the current user, and also check that the database file itself is read- and writeable (rw or octal 6).

  • Can you please tell me how to check it? Since I am unable to find any settings.
    – Sarah
    Mar 18 '13 at 11:27

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .