MS Access won’t open the ODBC Window
We use MySQL Databases with PHP front ends for pretty much all our organisations needs but occassionally we need to get something done before I can come up with a system for it. The most recent example was the collection of Contact data which would eventually be integrated into our main Customer database.
We let our Admin staff loose on the collection process and as I didn’t have any input, they used MS Excel to store the info. Now the time has come to add the info to our main MySQL Database and process it for any errors. To minimise the amount of work I’d have to do I wanted to use both Access and PHP to do some processing and data manipulation so I installed WAMP on my laptop and the Mysql ODBC Connector.
After loading up Access, I tried to connect to the MySQL table I’d created but after choosing:
File > Get External Data > Link Tables…
After choosing “ODBC Databases” from the Files of Type, nothing happens.
Turns out it is the “wonderful” Norton Internet Security at work again. You can fix it through the following method:
- In the System Tray, double-click the Norton icon
- Click Norton Internet Security.
- Click Settings.
- Click Additional Options, then Virus and Spyware Protection Options.
- Click Miscellaneous.
- Clear the Turn on scanning for Microsoft Office Documents check box.
Close Access if you had it open and then open your DB again. Should work fine now.
