"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:
>
>>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
>