Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Answer: Can I interface MS Access on Unix?

( #69967=categorized answer: print w/ replies, xml ) Need Help??

Q&A > database programming > 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

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

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (12)
As of 2014-09-22 16:26 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (198 votes), past polls