Solved

Link Unix Database to Micosoft Access

Posted on 2004-03-24
4
201 Views
Last Modified: 2010-04-21
Can I use Microsoft Access to link to a Unix database?
0
Comment
Question by:humbleservant77
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
Alf666 earned 20 total points
ID: 10676323
Yes. But you'll need the proper ODBC driver. MySQL, Postgresql and Oracle all have one.
Then you'll have to go to control panel, Administrative tools, Data sources (ODBC), and add the proper entry there
Or, for a one time use, you can just do that in access.

In access, just ask to link to an external table.

You might encounter problems though if you "unix" db tables don't have a single key. Access needs a single key per entry.
0
 
LVL 9

Expert Comment

by:Alf666
ID: 10682492
Hi, did this comment answer your question ?
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tech tip describes how to install the Solaris Operating System from a tape backup that was created using the Solaris flash archive utility. I have used this procedure on the Solaris 8 and 9 OS, and it shoudl also work well on the Solaris 10 rel…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question