Linked Table Names

When linking tables from SQL 2K to Access 2K using ODBC, I
get the owner (usually dbo) as a qualifier. It appears
that this just started happening. If I do not disturb the
old link without a qualifir, I am usually OK, but if I
release a link and relink, the dbo_ comes in, and my
queries do not recognize the table. Can I get rid of the
qualifier, and why would this have started to occur?
Thanks.If you link the tables programmatically, you can set the
name of the linked table. You can find sample code in the
following article:
Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm
-Sue
On Thu, 5 Aug 2004 11:25:07 -0700, "W D Greene"
<anonymous@.discussions.microsoft.com> wrote:

>When linking tables from SQL 2K to Access 2K using ODBC, I
>get the owner (usually dbo) as a qualifier. It appears
>that this just started happening. If I do not disturb the
>old link without a qualifir, I am usually OK, but if I
>release a link and relink, the dbo_ comes in, and my
>queries do not recognize the table. Can I get rid of the
>qualifier, and why would this have started to occur?
>Thanks.