Democratic Underground Latest Greatest Lobby Journals Search Options Help Login
Google

JCCyC's Geeky Tip of the Day: Stuck with MS Access?

Printer-friendly format Printer-friendly format
Printer-friendly format Email this thread to a friend
Printer-friendly format Bookmark this thread
This topic is archived.
Home » Discuss » The DU Lounge Donate to DU
 
Commie Pinko Dirtbag Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Apr-07-04 01:47 PM
Original message
JCCyC's Geeky Tip of the Day: Stuck with MS Access?
mdbtools: http://mdbtools.sourceforge.net /

Nice overview at http://otn.oracle.com/pub/articles/gagne_access.html

New Life for Old Microsoft Access Data
By Marcel Gagn

Learn how to easily migrate Access data to the Oracle Database on Linux using open-source tools

One of the sad facts about our relentless journey forward in the world of computers and software is that we sometimes find ourselves abandoning old data. We move from one word processing office package to another, only to discover that our old documents can no longer be opened.

The same is true of databases. A small shop may find that storing information on a PC database is sufficient, but what happens when it's time to move? We may gripe about leaving our valuable information behind, but we often do leave it. However, what may have seemed unimportant enough to abandon at the time can sometimes demand our attention.

I recently had just such a problem. A community organization I worked with had a PC-based application with a rather large membership database in Microsoft Access format. A custom program from a third party had been written to work with the database, but in time the license had expired and there was no longer a way to get an update of the software. As luck would have it, the information had suddenly become important again. We had the old database backed up and stored on a Linux system. In our new open source world, plenty of powerful databases, such as the Oracle Database on Linux, were available to us. One option would have been to purchase a copy of Microsoft Access and create an application, but that would have involved locking ourselves into the same proprietary mold that had gotten us into this mess in the first place. Furthermore, the organization wanted to be able to access this data remotely from a secure server.

(...)

Looking around for solutions to this dilemma led me to Brian Bruns' Web site and his mdbtools package, a collection of command-line tools plus a GUI whose sole purpose is to provide a way to extract information from Access databases. (...)
Printer Friendly | Permalink |  | Top
Commie Pinko Dirtbag Donating Member (1000+ posts) Send PM | Profile | Ignore Wed Apr-07-04 03:17 PM
Response to Original message
1. GNU/Kick
:kick:
Printer Friendly | Permalink |  | Top
 
DU AdBot (1000+ posts) Click to send private message to this author Click to view 
this author's profile Click to add 
this author to your buddy list Click to add 
this author to your Ignore list Sat Aug 23rd 2014, 04:37 AM
Response to Original message
Advertisements [?]
 Top

Home » Discuss » The DU Lounge Donate to DU

Powered by DCForum+ Version 1.1 Copyright 1997-2002 DCScripts.com
Software has been extensively modified by the DU administrators


Important Notices: By participating on this discussion board, visitors agree to abide by the rules outlined on our Rules page. Messages posted on the Democratic Underground Discussion Forums are the opinions of the individuals who post them, and do not necessarily represent the opinions of Democratic Underground, LLC.

Home  |  Discussion Forums  |  Journals |  Store  |  Donate

About DU  |  Contact Us  |  Privacy Policy

Got a message for Democratic Underground? Click here to send us a message.

© 2001 - 2011 Democratic Underground, LLC