Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Can I interface MS Access on Unix?

by Anonymous Monk
on Apr 04, 2001 at 03:58 UTC ( #69509=categorized question: print w/replies, xml ) Need Help??
Contributed by Anonymous Monk on Apr 04, 2001 at 03:58 UTC
Q&A  > database programming


Load up Access to UNIX and connect to it in UNIX, since there is an ODBC Driver?

Answer: Can I interface MS Access on Unix?
contributed by Coyote

I don't know of any way to access and Access databased directly from Unix, however if you have a networked Windows box available, you can use the DBI::ProxyServer module from CPAN in conjunction with <a href='>DBD::ODBC to set up a simple database server for the Access database on the Windows machine. You can now use the DBD::Proxy driver in a script on the Unix side to access the database just like you would any other DBI compatible datasource. Its ugly, round about solution but it works.

Answer: Can I interface MS Access on Unix?
contributed by LucidMatrix

This is slightly round about, but it works, I've done it for quick demos of this and that.

Use MySQL and create all of your tables in this. the same SQL statments can create the tables in ACCESS later, so you aren't wasting efforts.

Install the ODBC MySQL client on the windows machine, and connect it to the Unix database on the server.

Now, connect, don't import, .. connect/link in Access each of the data files you want to use in your ACCESS program.

That's it. Any information changed on the MySQL server will now also be live on your MS Access server. A small warning, MS Access will never give you the performace that you will have on the server with MySQL, but you can write all of the VB progarms you want and they will treat the linked data files just like Access data files.

Hope this helps and good luck

Answer: Can I interface MS Access on Unix?
contributed by jorg

Wouldn't think you can access Access from Unix through ODBC.. (please correct me if this has been done.. a quick search didn't return anything usefull).
How about the following : you run an IIS (or your choice of webserver) on that windows machine with a CGI script (perl ofcourse (: ) that accepts a query/odbc name as parameters, then goes off to query your access database through DBD::ODBC and returns you a resultset delimited and separated as whatever you want.

Answer: Can I interface MS Access on Unix?
contributed by hacker_j99

Currently you can use FreeTDS ( with some tweaks) or Sybase and use DBD::SYBASE insead of DBD::ODBC...

Please (register and) log in if you wish to add an answer

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others contemplating the Monastery: (2)
    As of 2018-12-10 03:48 GMT
    Find Nodes?
      Voting Booth?
      How many stories does it take before you've heard them all?

      Results (47 votes). Check out past polls.

      • (Sep 10, 2018 at 22:53 UTC) Welcome new users!