SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:03 PM
| |||
| |||
 Re: Linked SQL Server table in Access 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      |
|
02-27-2008, 09:06 PM
| ||||
| ||||
| Re: Linked SQL Server table in Access 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: > >>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 > |
Linear Mode
