Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Answer: Can I interface MS Access on Unix?

by LucidMatrix (Initiate)
on Apr 05, 2001 at 05:12 UTC ( #69967=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > Can I interface MS Access on Unix? - Answer 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

  • Comment on Answer: Can I interface MS Access on Unix?
Log In?

What's my password?
Create A New User
and the monks are mute...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2018-03-25 00:36 GMT
Find Nodes?
    Voting Booth?
    When I think of a mole I think of:

    Results (299 votes). Check out past polls.