Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Unable to link tables in MDB file using ODBC

Discussion in 'Information Technology' started by George, Jul 28, 2006.

  1. George

    George
    Expand Collapse
    Guest

    When I try to link tables in a MDB file using ODBC, no dialog box appears.
    Anyone know what is wrong? I am having this problem on several different
    computers. All running XP Pro Sp2 with Office PRO installed and all updates
    applied.
    --
    George
     
  2. Loading...

    Similar Threads Forum Date
    World Italy Chief Unable to Appear before Akaal Takht Breaking News Jul 23, 2011
    Controversial Unable to provide relief to ‘aam admi’ Senior bureaucrat seeks premature retirement Hard Talk Apr 14, 2010
    Sikh News Cash-starved Punjab unable to take call on octroi (Express India) Breaking News Feb 16, 2008
    Eh Janam Tumhare Lekhe... Official Movie Link... Announcements Jun 3, 2015
    Sikhism Complete Shalok Mehala 9 (Link) Videos Apr 22, 2014

  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

    Well, Some type of dialog box should appear...

    However, you can't use ms-access to link to a mdb access database with
    odbc....

    It simply don't work...and is not allowed.

    Since a ODBC link actually has to link though JET, which then in turn
    resolves to a actual file location on disk. Thus, you can't use a odbc link
    to a mdb file....

    You can, and most certainly should be able to create a linked table to
    another mdb file, but this is not a odbc link....

    To link to a table in another file, in the tables tab, choose new->link
    table...

    From the file dialog box...don't choose odbc...but simply choose

    "Microsoft Office Access (*.mdb, *mda, *.mde)"

    Something similar should appear in the drop down list.... --- of course
    ODBC() database also appears in the above drop down list, but as mentioned,
    ms-access will not let you do this...

    Or, did I miss read your question...and you are talking about the linked
    table manager for *existing* tables?


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal


    --
    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
    pleaseNOOSpamKallal@msn.com
    http://www.members.shaw.ca/AlbertKallal
     
  4. George

    George
    Expand Collapse
    Guest

    I found the problem... It is Norton's Antivirus Office Plug-in. By disabling
    this option, I was able to get the dialog box to appear. Problem solved and
    it wasn't an Access problem. Thanks....
    --
    George


    "Albert D.Kallal" wrote:

    > Well, Some type of dialog box should appear...
    >
    > However, you can't use ms-access to link to a mdb access database with
    > odbc....
    >
    > It simply don't work...and is not allowed.
    >
    > Since a ODBC link actually has to link though JET, which then in turn
    > resolves to a actual file location on disk. Thus, you can't use a odbc link
    > to a mdb file....
    >
    > You can, and most certainly should be able to create a linked table to
    > another mdb file, but this is not a odbc link....
    >
    > To link to a table in another file, in the tables tab, choose new->link
    > table...
    >
    > From the file dialog box...don't choose odbc...but simply choose
    >
    > "Microsoft Office Access (*.mdb, *mda, *.mde)"
    >
    > Something similar should appear in the drop down list.... --- of course
    > ODBC() database also appears in the above drop down list, but as mentioned,
    > ms-access will not let you do this...
    >
    > Or, did I miss read your question...and you are talking about the linked
    > table manager for *existing* tables?
    >
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
    >
    > --
    > Albert D. Kallal (Access MVP)
    > Edmonton, Alberta Canada
    > pleaseNOOSpamKallal@msn.com
    > http://www.members.shaw.ca/AlbertKallal
    >
    >
    >
    >
    >
    >
     
  5. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    it is an access problem.

    mdb is dangerous and obsolete run away while you still can!
     

Share This Page