As the subject line indicates, I'm trying to link MySQL tables into MS Access in order to provide a quickie interface for rapid data entry, etc.
I've installed MyODBC 3.51, the latest MDAC and just about every other possible upgrade I can think of that might be considered remotely relevant. Probably a few that aren't, too.
I can create the DSN just fine. It even tests out fine from the DSN dialogue box. Says I'm connected and life is good. When I open Access, though, and try to link the tables ... I get a very problematic, very unhelpful error message.
"Reserved error (-7778); there is no message for this error."
I've seen several references to this problem on the web, but no one seems to have any answers.