Solved

Link Unix Database to Micosoft Access

Posted on 2004-03-24
4
204 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
Using libpcap/Jpcap to capture and send packets on Solaris version (10/11) Library used: 1.      Libpcap (http://www.tcpdump.org) Version 1.2 2.      Jpcap(http://netresearch.ics.uci.edu/kfujii/Jpcap/doc/index.html) Version 0.6 Prerequisite: 1.      GCC …
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…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

717 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