What interfaces besides MS Access are available to manipulate MDB files












5














A few years ago I was developing a .NET application for a client that used Microsoft Access. Regardless of the merits of this technical decision, I ended up writing my own query editor for Microsft Access and SQLite files.



I have since found out I was not the only one to do so.



Please, one program per answer.










share|improve this question
























  • Are you trying to ask a question or promote your own software ?
    – Bruce McLeod
    Jul 27 '09 at 11:08










  • Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program.
    – Justin Dearing
    Jul 27 '09 at 12:46
















5














A few years ago I was developing a .NET application for a client that used Microsoft Access. Regardless of the merits of this technical decision, I ended up writing my own query editor for Microsft Access and SQLite files.



I have since found out I was not the only one to do so.



Please, one program per answer.










share|improve this question
























  • Are you trying to ask a question or promote your own software ?
    – Bruce McLeod
    Jul 27 '09 at 11:08










  • Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program.
    – Justin Dearing
    Jul 27 '09 at 12:46














5












5








5


1





A few years ago I was developing a .NET application for a client that used Microsoft Access. Regardless of the merits of this technical decision, I ended up writing my own query editor for Microsft Access and SQLite files.



I have since found out I was not the only one to do so.



Please, one program per answer.










share|improve this question















A few years ago I was developing a .NET application for a client that used Microsoft Access. Regardless of the merits of this technical decision, I ended up writing my own query editor for Microsft Access and SQLite files.



I have since found out I was not the only one to do so.



Please, one program per answer.







microsoft-access jetsql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Oct 14 '09 at 21:58


























community wiki





3 revs, 3 users 100%
Justin Dearing














  • Are you trying to ask a question or promote your own software ?
    – Bruce McLeod
    Jul 27 '09 at 11:08










  • Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program.
    – Justin Dearing
    Jul 27 '09 at 12:46


















  • Are you trying to ask a question or promote your own software ?
    – Bruce McLeod
    Jul 27 '09 at 11:08










  • Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program.
    – Justin Dearing
    Jul 27 '09 at 12:46
















Are you trying to ask a question or promote your own software ?
– Bruce McLeod
Jul 27 '09 at 11:08




Are you trying to ask a question or promote your own software ?
– Bruce McLeod
Jul 27 '09 at 11:08












Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program.
– Justin Dearing
Jul 27 '09 at 12:46




Bruce, Actually, I'd like to use something else now that I know better things exist. Unfortunately, there seems to be a lack of interest in a propry SQL editor for MS Access. That being said, I want this list to be as exhaustive as possible, and therefor it includes my program.
– Justin Dearing
Jul 27 '09 at 12:46










6 Answers
6






active

oldest

votes


















2














Oracle SQL developer works as well. It also connects to Oracle, MySql (no surprises) SQL Server, Sybase and DB2. See Database Connections on the feature list






share|improve this answer























  • I think I have a new favorite
    – Justin Dearing
    Sep 10 '11 at 14:48



















1














PlaneDisaster.NET Is the program I wrote to accomplish this task. The user interface leaves a lot to be desired, but it got the job done.






share|improve this answer























  • i like your naming convention :)
    – quack quixote
    Oct 14 '09 at 22:03



















1














JetSQL Console is an open source command line only console app. Its written in QT, despite having no GUI. Its not very polished, but lets you manipulate MDB files via the command line.






share|improve this answer































    1














    Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.






    share|improve this answer























    • Marking this program as best of breed for now. If someone knows of a better program, let me know.
      – Justin Dearing
      Aug 17 '09 at 13:39



















    0














    Sometimes I use AnySQL Maestro. The free version targes anything with an OLEDB driver.



    Similarly you can use free JDBC tools + ODBC drivers to target MS-Access (as a generic JDBC/ODBC) database, although I haven't tried this for a long time so I'm not sure what exists now-a-days.






    share|improve this answer























    • I will check out Maestro.
      – Justin Dearing
      Sep 15 '09 at 13:17



















    0














    MDBPlus works well and is able to open & edit very old Access databases.






    share|improve this answer























      Your Answer








      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "3"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f13602%2fwhat-interfaces-besides-ms-access-are-available-to-manipulate-mdb-files%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      6 Answers
      6






      active

      oldest

      votes








      6 Answers
      6






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      2














      Oracle SQL developer works as well. It also connects to Oracle, MySql (no surprises) SQL Server, Sybase and DB2. See Database Connections on the feature list






      share|improve this answer























      • I think I have a new favorite
        – Justin Dearing
        Sep 10 '11 at 14:48
















      2














      Oracle SQL developer works as well. It also connects to Oracle, MySql (no surprises) SQL Server, Sybase and DB2. See Database Connections on the feature list






      share|improve this answer























      • I think I have a new favorite
        – Justin Dearing
        Sep 10 '11 at 14:48














      2












      2








      2






      Oracle SQL developer works as well. It also connects to Oracle, MySql (no surprises) SQL Server, Sybase and DB2. See Database Connections on the feature list






      share|improve this answer














      Oracle SQL developer works as well. It also connects to Oracle, MySql (no surprises) SQL Server, Sybase and DB2. See Database Connections on the feature list







      share|improve this answer














      share|improve this answer



      share|improve this answer








      answered Sep 10 '11 at 5:01


























      community wiki





      Conrad Frix













      • I think I have a new favorite
        – Justin Dearing
        Sep 10 '11 at 14:48


















      • I think I have a new favorite
        – Justin Dearing
        Sep 10 '11 at 14:48
















      I think I have a new favorite
      – Justin Dearing
      Sep 10 '11 at 14:48




      I think I have a new favorite
      – Justin Dearing
      Sep 10 '11 at 14:48













      1














      PlaneDisaster.NET Is the program I wrote to accomplish this task. The user interface leaves a lot to be desired, but it got the job done.






      share|improve this answer























      • i like your naming convention :)
        – quack quixote
        Oct 14 '09 at 22:03
















      1














      PlaneDisaster.NET Is the program I wrote to accomplish this task. The user interface leaves a lot to be desired, but it got the job done.






      share|improve this answer























      • i like your naming convention :)
        – quack quixote
        Oct 14 '09 at 22:03














      1












      1








      1






      PlaneDisaster.NET Is the program I wrote to accomplish this task. The user interface leaves a lot to be desired, but it got the job done.






      share|improve this answer














      PlaneDisaster.NET Is the program I wrote to accomplish this task. The user interface leaves a lot to be desired, but it got the job done.







      share|improve this answer














      share|improve this answer



      share|improve this answer








      answered Jul 27 '09 at 11:05


























      community wiki





      Justin Dearing













      • i like your naming convention :)
        – quack quixote
        Oct 14 '09 at 22:03


















      • i like your naming convention :)
        – quack quixote
        Oct 14 '09 at 22:03
















      i like your naming convention :)
      – quack quixote
      Oct 14 '09 at 22:03




      i like your naming convention :)
      – quack quixote
      Oct 14 '09 at 22:03











      1














      JetSQL Console is an open source command line only console app. Its written in QT, despite having no GUI. Its not very polished, but lets you manipulate MDB files via the command line.






      share|improve this answer




























        1














        JetSQL Console is an open source command line only console app. Its written in QT, despite having no GUI. Its not very polished, but lets you manipulate MDB files via the command line.






        share|improve this answer


























          1












          1








          1






          JetSQL Console is an open source command line only console app. Its written in QT, despite having no GUI. Its not very polished, but lets you manipulate MDB files via the command line.






          share|improve this answer














          JetSQL Console is an open source command line only console app. Its written in QT, despite having no GUI. Its not very polished, but lets you manipulate MDB files via the command line.







          share|improve this answer














          share|improve this answer



          share|improve this answer








          answered Jul 27 '09 at 11:11


























          community wiki





          Justin Dearing
























              1














              Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.






              share|improve this answer























              • Marking this program as best of breed for now. If someone knows of a better program, let me know.
                – Justin Dearing
                Aug 17 '09 at 13:39
















              1














              Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.






              share|improve this answer























              • Marking this program as best of breed for now. If someone knows of a better program, let me know.
                – Justin Dearing
                Aug 17 '09 at 13:39














              1












              1








              1






              Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.






              share|improve this answer














              Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.







              share|improve this answer














              share|improve this answer



              share|improve this answer








              answered Jul 27 '09 at 11:12


























              community wiki





              Justin Dearing













              • Marking this program as best of breed for now. If someone knows of a better program, let me know.
                – Justin Dearing
                Aug 17 '09 at 13:39


















              • Marking this program as best of breed for now. If someone knows of a better program, let me know.
                – Justin Dearing
                Aug 17 '09 at 13:39
















              Marking this program as best of breed for now. If someone knows of a better program, let me know.
              – Justin Dearing
              Aug 17 '09 at 13:39




              Marking this program as best of breed for now. If someone knows of a better program, let me know.
              – Justin Dearing
              Aug 17 '09 at 13:39











              0














              Sometimes I use AnySQL Maestro. The free version targes anything with an OLEDB driver.



              Similarly you can use free JDBC tools + ODBC drivers to target MS-Access (as a generic JDBC/ODBC) database, although I haven't tried this for a long time so I'm not sure what exists now-a-days.






              share|improve this answer























              • I will check out Maestro.
                – Justin Dearing
                Sep 15 '09 at 13:17
















              0














              Sometimes I use AnySQL Maestro. The free version targes anything with an OLEDB driver.



              Similarly you can use free JDBC tools + ODBC drivers to target MS-Access (as a generic JDBC/ODBC) database, although I haven't tried this for a long time so I'm not sure what exists now-a-days.






              share|improve this answer























              • I will check out Maestro.
                – Justin Dearing
                Sep 15 '09 at 13:17














              0












              0








              0






              Sometimes I use AnySQL Maestro. The free version targes anything with an OLEDB driver.



              Similarly you can use free JDBC tools + ODBC drivers to target MS-Access (as a generic JDBC/ODBC) database, although I haven't tried this for a long time so I'm not sure what exists now-a-days.






              share|improve this answer














              Sometimes I use AnySQL Maestro. The free version targes anything with an OLEDB driver.



              Similarly you can use free JDBC tools + ODBC drivers to target MS-Access (as a generic JDBC/ODBC) database, although I haven't tried this for a long time so I'm not sure what exists now-a-days.







              share|improve this answer














              share|improve this answer



              share|improve this answer








              answered Sep 14 '09 at 17:28


























              community wiki





              MatthewMartin













              • I will check out Maestro.
                – Justin Dearing
                Sep 15 '09 at 13:17


















              • I will check out Maestro.
                – Justin Dearing
                Sep 15 '09 at 13:17
















              I will check out Maestro.
              – Justin Dearing
              Sep 15 '09 at 13:17




              I will check out Maestro.
              – Justin Dearing
              Sep 15 '09 at 13:17











              0














              MDBPlus works well and is able to open & edit very old Access databases.






              share|improve this answer




























                0














                MDBPlus works well and is able to open & edit very old Access databases.






                share|improve this answer


























                  0












                  0








                  0






                  MDBPlus works well and is able to open & edit very old Access databases.






                  share|improve this answer














                  MDBPlus works well and is able to open & edit very old Access databases.







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  answered Dec 20 '18 at 18:26


























                  community wiki





                  DaveInCaz































                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Super User!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.





                      Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


                      Please pay close attention to the following guidance:


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f13602%2fwhat-interfaces-besides-ms-access-are-available-to-manipulate-mdb-files%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      Probability when a professor distributes a quiz and homework assignment to a class of n students.

                      Aardman Animations

                      Are they similar matrix