Link tables ODBC

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jo M - 22 May 2008 09:30 GMT

I have installed a driver which links to a MySQL database (tests successfully)
However, when I try to link to the tables in Access 2003 nothing happens
(the connection wizard fails to run)
I press Get Externa Data, Link Tables and when I choose ODBC Databases
....nothing happens.
I can link to other access databases etc.

I have since installed Access2007 and can sucessfully link to the tables
through there.
Can anyone tell me what has happened to my ODBC database connection wizard?

Thanks!

Reply to this Message

Chris O'C - 22 May 2008 12:48 GMT

If you have Norton antivirus installed, disable the office plug-in and link
to the mysql table. Make sure you enable the office plug-in again.

Chris
Microsoft MVP

>I have installed a driver which links to a MySQL database (tests successfully)
>However, when I try to link to the tables in Access 2003 nothing happens
[quoted text clipped - 8 lines]
>
>Thanks!

Reply to this Message

Jo M - 22 May 2008 22:49 GMT

Thanks Chris,

I disabled the Scan Office documents, which was the only setting I could
find. It didn't work however, is that the setting you were referring to?

> If you have Norton antivirus installed, disable the office plug-in and link
> to the mysql table. Make sure you enable the office plug-in again.
[quoted text clipped - 14 lines]
> >
> >Thanks!

Reply to this Message

Chris O'C - 22 May 2008 23:18 GMT

Here are the instructions:

http://groups.google.com/group/microsoft.public.access.externaldata/browse_frm/t
hread/7aebedf9e491e35b/aff4603374adb1ed?tvc=1&hl=en#aff4603374adb1ed

Chris
Microsoft MVP

>Thanks Chris,
>
[quoted text clipped - 6 lines]
>> >
>> >Thanks!

Reply to this Message