Access SQL Passthrough queries should accomplish this.
>[mailto:pgsql-odbc-owner(at)postgresql(dot)org] On Behalf Of Stephen Frost
>Sent: Tuesday, August 17, 2010 4:04 PM
>To: Benjamin Smith
>Subject: Re: [ODBC] MS Access and field-level permissions?
>* Benjamin Smith (lists(at)benjamindsmith(dot)com) wrote:
>> This may be a PG issue and not an ODBC issue, but Filemaker
>> fine with
>> the restrictive permissions, MS Access is where things break.
>It's actually a SQL spec requirement..
>You should be able to create queries in access against just
>the fields the user(s) have access to against the linked table
>(I'd hope anyway, but I'm not an Access expert). An
>alternative would be to create views that only pull through
>the columns you want visible to your Access users.
In response to
pgsql-odbc by date
|Next:||From: Lord_Devi||Date: 2010-08-18 05:45:54|
|Subject: OpenOffice, Go-OO, ODBC, Offline Data Entry|
|Previous:||From: Stephen Frost||Date: 2010-08-17 23:04:07|
|Subject: Re: MS Access and field-level permissions?|