Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002
    Location
    Baltimore, MD
    Posts
    26

    Unanswered: Using Access as a Front End

    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.

    Any help would be greatly appreciated.

    Anyone?
    Rob Wilkerson

  2. #2
    Join Date
    Feb 2002
    Location
    Sydney
    Posts
    21
    The 3.51 ODBC drivers are experimental, and don't work for me (or you). Try the 2.59 line

  3. #3
    Join Date
    Feb 2002
    Location
    Baltimore, MD
    Posts
    26
    Bingo. Thanks for the information. Surprisingly simple, but greatly appreciated.
    Rob Wilkerson

  4. #4
    Join Date
    May 2002
    Location
    Ark. USA
    Posts
    3

    myODBC choices

    additional info on this, we have to use myodbc 2.59 with Access 2000, but this will not work with Visual FoxPro 5 or 7, which seem to require myodbc 3.51 to work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •