What interfaces besides MS Access are available to manipulate MDB files
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
add a comment |
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
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
add a comment |
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
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
microsoft-access jetsql
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
add a comment |
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
add a comment |
6 Answers
6
active
oldest
votes
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
I think I have a new favorite
– Justin Dearing
Sep 10 '11 at 14:48
add a comment |
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.
i like your naming convention :)
– quack quixote
Oct 14 '09 at 22:03
add a comment |
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.
add a comment |
Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.
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
add a comment |
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.
I will check out Maestro.
– Justin Dearing
Sep 15 '09 at 13:17
add a comment |
MDBPlus works well and is able to open & edit very old Access databases.
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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
I think I have a new favorite
– Justin Dearing
Sep 10 '11 at 14:48
add a comment |
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
I think I have a new favorite
– Justin Dearing
Sep 10 '11 at 14:48
add a comment |
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
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
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
add a comment |
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
add a comment |
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.
i like your naming convention :)
– quack quixote
Oct 14 '09 at 22:03
add a comment |
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.
i like your naming convention :)
– quack quixote
Oct 14 '09 at 22:03
add a comment |
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.
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.
answered Jul 27 '09 at 11:05
community wiki
Justin Dearing
i like your naming convention :)
– quack quixote
Oct 14 '09 at 22:03
add a comment |
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
add a comment |
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.
add a comment |
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.
add a comment |
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.
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.
answered Jul 27 '09 at 11:11
community wiki
Justin Dearing
add a comment |
add a comment |
Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.
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
add a comment |
Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.
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
add a comment |
Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.
Yes another open source gui app for doing this is MS Access Databases Queries Editor. It has a better looking GUI than PlaneDisaster.NET.
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
add a comment |
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
add a comment |
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.
I will check out Maestro.
– Justin Dearing
Sep 15 '09 at 13:17
add a comment |
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.
I will check out Maestro.
– Justin Dearing
Sep 15 '09 at 13:17
add a comment |
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.
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.
answered Sep 14 '09 at 17:28
community wiki
MatthewMartin
I will check out Maestro.
– Justin Dearing
Sep 15 '09 at 13:17
add a comment |
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
add a comment |
MDBPlus works well and is able to open & edit very old Access databases.
add a comment |
MDBPlus works well and is able to open & edit very old Access databases.
add a comment |
MDBPlus works well and is able to open & edit very old Access databases.
MDBPlus works well and is able to open & edit very old Access databases.
answered Dec 20 '18 at 18:26
community wiki
DaveInCaz
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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