Author Topic: Convert Access (mdb) tpdb8 database to SQLite  (Read 2569 times)

0 Members and 1 Guest are viewing this topic.

David Dyer-Bennet

  • Member
  • **
  • Posts: 21
    • View Profile
Convert Access (mdb) tpdb8 database to SQLite
« on: 2014-05-24 21:04:14 »
When I first made the choice, long ago, I stuck with Access.  That's now wrong for me, and I'm in danger of bumping up against the file size limit too.  I used to have a working Access 97, but that's not much use with Access 200 files, and there's now more available for SQLite anyway.  

But there doesn't seem to be any way to convert my existing database to a different format.  Since much of the keywording exists only in the database (because Thumbs Plus doesn't know how to write some of my file formats), just trashing it and starting over is out of the question.

Ideally I might want to change to storing the thumbnails in files, too; not sure if that's a win for SQLite or not.  

How come this is so hard? I see lots of discussions of various conversion issues, and no good answers for this one.  Exporting and importing fails mysteriously with an error saying the file format is wrong.