Link Unix Database to Micosoft Access

Can I use Microsoft Access to link to a Unix database?
humbleservant77Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Alf666Connect With a Mentor Commented:
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
 
Alf666Commented:
Hi, did this comment answer your question ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.