Unable to link tables in MDB file using ODBC

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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?
 
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....
 
it is an access problem.

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