any thoughts
"david" <david@[EMAIL PROTECTED]
> wrote in message
news:O9cs4oK3IHA.1200@[EMAIL PROTECTED]
> What you see in the linked table wizard are tables
> in the default schema.
>
> If you have tables in a different schema, you need
> to specify that in your link or possibly in your DSN.
>
> If you can't do that with the linked table wizard, you
> may have to write (copy from the web) your own
> link code. Tables names are linked as [dbo].[tablename]
> instead of just [tablename].
>
> If you have any questions specifically about [schema],
> probably better to ask in microsoft.public.access.odbcclientsvr.
> I had tables from two schema and it seemed to work ok,
> but we fixed it a soon as we could, so I don't know if there
> are any obscure problems.
>
> (david)
>
> )
>
>
> "AHartman" <Hoosbruin@[EMAIL PROTECTED]
> wrote in message
> news:r5qdnchdxpf0k_HVnZ2dnUVZ_s_inZ2d@[EMAIL PROTECTED]
>> I'm running Sql2005 sp2 and created a couple of tables within there own
>> schema(for security reasons). I then created a group within AD a gave
>> that group read/write/update permissions those tables within that
>> schema. I then have my users try and connect to the tables via Access
an
>> ODBC connection but the users can't view the tables They don't show up
in
>> the list of tables is that becuase there not in he dbo schema?
>>
>> any thoughts?
>>
>>
>> Thanks
>
>
