[AccessD] Link to AdventureWorks Database

[Arthur Fuller]

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