[AccessD] Link to AdventureWorks Database

[Arthur Fuller]

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