ODBC Connection problem in Access

ODBC Connection problem in Access

Post by Qm95Z » Sat, 12 Aug 2006 05:29:01


I have the ODBC connection setup successfully, when i go into Access and
choose to link the tables, I select ODBC from the dropdown and nothing
happens. The help files state that I must not have Jet installed, i have
validated the Jet installation. I can get the setup to work on other PC's,
however i can not get it to work on my main PC.

Any ideas?
 
 
 

ODBC Connection problem in Access

Post by Albert D. » Sat, 12 Aug 2006 08:34:31

Well, you can't use a odbc link to link to a ms-access table from
ms-access!! (I am not kidding!!!).

Since you can't do the above...simply create a linked table..but, don't
choose odbc..but choose...
files of type......mdb...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM

 
 
 

ODBC Connection problem in Access

Post by Qm95Z » Sat, 12 Aug 2006 22:57:02

I am linking to an MySql database, like i said in the first post this works
on other machines just fine.
 
 
 

ODBC Connection problem in Access

Post by Albert D. » Sun, 13 Aug 2006 01:43:11


silly me...I missed the part about it works on other machines....

Hum, try re-installing the mysql odbc drivers?


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
XXXX@XXXXX.COM