[AccessD] Link to AdventureWorks Database

[Arthur Fuller]

I'm in! Hooray! Thanks for the assistance.

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

> Still having trouble. In the New Data Source dialog, I see several entries:
> ODBC Driver for SQL Server
> SQL Server
> SQL Server Native Client 11.0
> SQL Server Native Client RDA 11.0
> Which of these did you choose? I selected SQL Server. Perhaps that was
> wrong. While I await your response, I will try the ODBC driver instead.
>
> On Tue, Jan 10, 2023 at 10:18 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
>> 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
>>
>>
>
> --
> Arthur
>
>

-- 
Arthur