[AccessD] Link to AdventureWorks Database

Arthur Fuller fuller.artful at gmail.com
Tue Jan 10 09:18:13 CST 2023


Interesting. I shall try it again. Thanks for looking into it.

On Tue, Jan 10, 2023 at 9:57 AM Ryan W <wrwehler at gmail.com> wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur


More information about the AccessD mailing list