ODBC "link table" dialog box immediately disappears in Access 2003

Question

Post reply

ODBC "link table" dialog box immediately disappears in Access 2003

Ken Wells

Old Hand

Points: 326
More actions
March 31, 2007 at 11:16 am

#68477

I am attempting to create an ODBC link to a SQL 2005 table from Access 2003. I have already created the file dsn. When I try to USE the file dsn in Access (via the menu selections File, Get External Data, Link Tables) as soon as I click on the drop-down selection "ODBC Databases ()", the dialog box immediately closes. It does not even allow me to point to the dsn.
None of the other file types in the drop-down list cause this behavior.
Any ideas of what could cause this to happen?
Thanks,
Ken Wells.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32350 More actions · Answer 1

Does Access 2003 have the latest service pack applied ?(To rule out some possible bugs)

Ken Wells Old Hand Points: 326 More actions · Answer 2

Yes, it is up to date.

Thanks for the suggestion, though.

Jo Pattyn SSC-Dedicated Points: 32350 More actions · Answer 3

Have you found any info in the windows error log? (start->execute->eventvwr)

Rick Pearson-465417 Grasshopper Points: 10 More actions · Answer 4

Did you ever find the solution to your problem? I'm having the same issue.

Perry Harts Ten Centuries Points: 1271 More actions · Answer 5

Have you tried adding your dsn to ODBC Data Source Administrator on the "File DSN" tab under from the control panel? That may help.

mrpolecat SSCertifiable Points: 7014 More actions · Answer 6

Here is some code to link a table. Won't fix your problem but may get you past it.

Function linkdata(tablename,dsnname)

DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=" & dsnname & ";;TABLE=" & tablename, acTable, tablename, tablename, False

End Function

Rick Pearson-465417 Grasshopper Points: 10 More actions · Answer 7

Problem solved.

Norton Anti-Virus seems to be the culprit here.

If you disable the Office Plug-in, the ODBC Administrator window will open correctly.

How to disable the Office Plug-in:

1. Open Norton AntiVius

2. Select Options, Norton AntiVirus

3. In section Other, select Miscellaneous

4. Unselect Turn Office Plug-in on

Thanks for all your input.

Rick Pearson

Ken Wells Old Hand Points: 326 More actions · Answer 8

Thanks all for the good info. I have not tried the Norton Anti-Virus solution, but I bet that's the answer. I have Norton Anti-Virus installed. I will try the solution and see what happens.

Thanks again,

Ken Wells.

mike-737404 Grasshopper Points: 13 More actions · Answer 9

Thanks for the info here. Hit the same problem, and yes, it was Norton. Incidentally, it was only a problem after I had installed Office SP3, previously this had worked OK.