Onno Broekmans wrote:
> Today, I installed MyODBC 3.51.12 on a Windows XP computer to access a
> *remote* MySQL database through Microsoft Access 2002 (XP). Testing the
> connection works perfectly.
> However, when I try to access the database through Access, MyODBC pops up
> a login form. On this login form (which is the same as the "Configure Data
> Source Name" dialog) everything is grayed out, except the username and
In the ODBC administration thing in Windows, make sure you set up your
connection under 'System DSN'. Neither 'User DSN' nor 'File DSN' have
ever worked for me. Perhaps another one for the 'working with MS Access'
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989