Post reply

Access gives error No -7776 for linked ODBC tables

  • July 2, 2006 at 8:07 am

    #69125

    I have created an Access front-end for a ODBC SQL server. I have connected all tables from single server through ODBC. I have a form with a subform on that form having tow different tables as their recordsources. Thse forms are linked for Master and Chiled fields. But Access gives error as 'Resered error -7776' when control jumps from Master form to subform. Why? Please suggest a solution for this.

    Thanks

    CPK

  • July 3, 2006 at 9:25 am

    #647245

    Have you tried (just testing) to see if this same error would happen using local tables?  Then try them in a second Access database, and use ODBC to connect them rather than the normal linking.  And a third thing to try is to recreate the two forms, and see if you get the same error.

    Vic

     

    [font="Comic Sans MS"]Vic[/font]
    www.vicrauch.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply