Linked SQL Server table in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max Yaffe - 19 Dec 2005 17:47 GMT

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

Reply to this Message

Sue Hoegemeier - 20 Dec 2005 01:03 GMT

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

>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

Reply to this Message

Randall Arnold - 31 Jan 2006 14:31 GMT

It's also really easy to just rename the table in Access if you need to.

Randall Arnold

> You can link the tables in code, naming them yourself or
> just rename the linked tables - it doesn't actually change
[quoted text clipped - 12 lines]
>>Thanks
>>Max

Reply to this Message