Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Link Unix Database to Micosoft Access

Posted on 2004-03-24
4
Medium Priority
?
216 Views
Last Modified: 2010-04-21
Can I use Microsoft Access to link to a Unix database?
0
Comment
Question by:humbleservant77
  • 2
2 Comments
 
LVL 9

Accepted Solution

by:
Alf666 earned 80 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…
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month9 days, 8 hours left to enroll

877 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