[AccessD] Link to AdventureWorks Database

[Ryan W]

What sort of problem are you having?

I just downloaded adventureworks and linked the HumanResources and Person
schemas. the tables are named such in access:

HumanResources.Department became HumanResources_Department

Person.Address became Person_Address



On Tue, Jan 10, 2023 at 8:30 AM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> That's what I am trying to do. It seems that Access is confused by the
> namespaces. The tables are not simply called <tablename> but rather
> <namespace>.<tablename>.
>
> On Tue, Jan 10, 2023 at 9:27 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > I've never tinkered with the AdventureWorks DB but if you need a one time
> > link just use the Linked Table Manager?
> >
> >
> >
> > On Tue, Jan 10, 2023 at 8:25 AM Arthur Fuller <fuller.artful at gmail.com>
> > wrote:
> >
> > > I am trying to figure out how to link Access to the SQL server
> > > AdventureWorks database. This database uses namespaces to gather the
> > tables
> > > into groups that describe their collective function: names such as
> > > Sales.TableName, and so on.
> > >
> > > Has anyone successfully linked to this particular database, or any
> other
> > > that uses namespaces? If so, how did you achieve this?
> > >
> > > --
> > > Arthur
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>