Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Alternative to SQLite or MSAccess

Alternative to SQLite or MSAccess

Scheduled Pinned Locked Moved Database
databasesqlitehelpquestion
7 Posts 3 Posters 13 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    lucausa75
    wrote on last edited by
    #1

    Any alternative to SQLite? I'm using an MSAccess database which uses a file to stoee all the data. I found SQLite which is using a file as database. The issue with SQLite is the missing way to protect this database with a password. That's why I need something similar to SQLite or MSAccess: does anyone know any alternative? What about firebird? Thanks

    V K 2 Replies Last reply
    0
    • L lucausa75

      Any alternative to SQLite? I'm using an MSAccess database which uses a file to stoee all the data. I found SQLite which is using a file as database. The issue with SQLite is the missing way to protect this database with a password. That's why I need something similar to SQLite or MSAccess: does anyone know any alternative? What about firebird? Thanks

      V Offline
      V Offline
      Victor Nijegorodov
      wrote on last edited by
      #2

      MS SQL Server Express Edition

      L 1 Reply Last reply
      0
      • L lucausa75

        Any alternative to SQLite? I'm using an MSAccess database which uses a file to stoee all the data. I found SQLite which is using a file as database. The issue with SQLite is the missing way to protect this database with a password. That's why I need something similar to SQLite or MSAccess: does anyone know any alternative? What about firebird? Thanks

        K Offline
        K Offline
        k5054
        wrote on last edited by
        #3

        Is this not useful? [SQLite Encryption Extension: Documentation](https://www.sqlite.org/see/doc/trunk/www/readme.wiki)

        "A little song, a little dance, a little seltzer down your pants" Chuckles the clown

        1 Reply Last reply
        0
        • V Victor Nijegorodov

          MS SQL Server Express Edition

          L Offline
          L Offline
          lucausa75
          wrote on last edited by
          #4

          Does MS SQL Server Express Edition create the database in a single file like MSAccess?

          V 1 Reply Last reply
          0
          • L lucausa75

            Does MS SQL Server Express Edition create the database in a single file like MSAccess?

            V Offline
            V Offline
            Victor Nijegorodov
            wrote on last edited by
            #5

            SQL Server creates two files for each DB: [Microsoft SQL Server Database Files & Internal Structure](https://www.bdrsuite.com/blog/microsoft-sql-server-database-files-internal-structure/)

            L 1 Reply Last reply
            0
            • V Victor Nijegorodov

              SQL Server creates two files for each DB: [Microsoft SQL Server Database Files & Internal Structure](https://www.bdrsuite.com/blog/microsoft-sql-server-database-files-internal-structure/)

              L Offline
              L Offline
              lucausa75
              wrote on last edited by
              #6

              Can I copy those two files in a different PC or directory in order to continue to use it? My idea is creating the database in PC A and move those files in a dedicated directory of PC B

              V 1 Reply Last reply
              0
              • L lucausa75

                Can I copy those two files in a different PC or directory in order to continue to use it? My idea is creating the database in PC A and move those files in a dedicated directory of PC B

                V Offline
                V Offline
                Victor Nijegorodov
                wrote on last edited by
                #7

                Probably. However, the best way would be to backup the DB on the PC A and then restore it on PC B.

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups