Linked SQL Server table in Access

Why does the ODBC Link Table utility prepend "dbo_" to each table I've
linked into an Access database? I realize dbo stands for database
owner, but why is this an issue? Can I get it to drop the "dbo_"?
Thanks
MaxYou can link the tables in code, naming them yourself or
just rename the linked tables - it doesn't actually change
the table name, just the name seen by Access.
Access adds that as you can have two tables in SQL Server
with the same name and different owners. You can have a
dbo.Customers and someuser.Customers. Access adds the owner
to differentiate the objects.
-Sue
On Mon, 19 Dec 2005 12:47:39 -0500, Max Yaffe
<myaffe@.not.gamry.com> wrote:

>Why does the ODBC Link Table utility prepend "dbo_" to each table I've
>linked into an Access database? I realize dbo stands for database
>owner, but why is this an issue? Can I get it to drop the "dbo_"?
>Thanks
>Max|||It's also really easy to just rename the table in Access if you need to.
Randall Arnold
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:tsleq1ha02a7ujoeo8oji2vo865g8m51bc@.
4ax.com...
> You can link the tables in code, naming them yourself or
> just rename the linked tables - it doesn't actually change
> the table name, just the name seen by Access.
> Access adds that as you can have two tables in SQL Server
> with the same name and different owners. You can have a
> dbo.Customers and someuser.Customers. Access adds the owner
> to differentiate the objects.
> -Sue
> On Mon, 19 Dec 2005 12:47:39 -0500, Max Yaffe
> <myaffe@.not.gamry.com> wrote:
>
>sql