I am running Microsoft Office 2007 on a Windows 7 (Home Premium) machine. I use ODBC to access several MySQL databases and, as I am the only user of this machine I like to use System DSN’s to make the connections.
I own this computer. I am the administrator, the big cheese. It is MY computer. But from within Access I cannot set up a system DSN because, it lies, I do not have admin privileges. Of course I have Admin privileges. I am the Administrator, and yes, I am logged in with Admin rights.
The Right-Click ‘Run as Administrator’ option does not exist for Access – can the TR community tell me how I can get round this? I have tried to set up File DSN’s but then Access moans about architecture differences. I have used Control Panel > Administrative Tools > Data Sources (ODBC) to set up a system DSN but then in Access, it isn’t listed as an option.
I appreciate Microsoft is probably trying to protect me from myself, but frankly I find that arrogant and extremely frustrating.
