Link To Selected Fields

[Steve]

I have a table in a database that is currently linked via ODBC to a sensitive
personnel table in another system. The database only needs such fields as name,
address and telephone number and does not need other sensitive fields such as
social security number and salary information. Is there a way to limit the ODBC
connection to only those fields that are needed? In the alternative, is there a
way in Access97 to keep someone who knows how to get to the tables from opening
the ODBC table and looking at it or worse yet making changes to the linked
table?

Thanks for all thoughts on how to deal with this situation!

Steve

[news.east.earthlink.net]

Re: Link To Selected Fields

You could use Access security and restrict the table from being viewed. Then
create a query with only the fields necessary and set owneraccess rights.
This is no easy task if you are not familiar with Access security.
THT
"Steve" <spam@nospam.sp am> wrote in message
news:z7EWb.1284 $W74.469@newsre ad1.news.atl.ea rthlink.net...[color=blue]
> I have a table in a database that is currently linked via ODBC to a[/color]
sensitive[color=blue]
> personnel table in another system. The database only needs such fields as[/color]
name,[color=blue]
> address and telephone number and does not need other sensitive fields such[/color]
as[color=blue]
> social security number and salary information. Is there a way to limit the[/color]
ODBC[color=blue]
> connection to only those fields that are needed? In the alternative, is[/color]
there a[color=blue]
> way in Access97 to keep someone who knows how to get to the tables from[/color]
opening[color=blue]
> the ODBC table and looking at it or worse yet making changes to the linked
> table?
>
> Thanks for all thoughts on how to deal with this situation!
>
> Steve
>
>[/color]

[Brendan Reynolds]

Re: Link To Selected Fields

In addition to the other suggestion you received, if you have access to, or
can get the cooperation of someone who has access to the server database,
create a view on the server database including only the required fields and
link the view instead of the table.

--
Brendan Reynolds


"Steve" <spam@nospam.sp am> wrote in message
news:z7EWb.1284 $W74.469@newsre ad1.news.atl.ea rthlink.net...[color=blue]
> I have a table in a database that is currently linked via ODBC to a[/color]
sensitive[color=blue]
> personnel table in another system. The database only needs such fields as[/color]
name,[color=blue]
> address and telephone number and does not need other sensitive fields such[/color]
as[color=blue]
> social security number and salary information. Is there a way to limit the[/color]
ODBC[color=blue]
> connection to only those fields that are needed? In the alternative, is[/color]
there a[color=blue]
> way in Access97 to keep someone who knows how to get to the tables from[/color]
opening[color=blue]
> the ODBC table and looking at it or worse yet making changes to the linked
> table?
>
> Thanks for all thoughts on how to deal with this situation!
>
> Steve
>
>[/color]

[Rod Scoullar]

Re: Link To Selected Fields

Steve,

A couple of possibilities:

If you turn off the Display Database Window option (and Use Access Special
Keys) in the Tools->Startup menu option and then create an .mde file of the
database you prevent anyone looking at any of the tables.

If you don't create the .mde file you won't see the tables but anyone is
able to turn the view database window back on.

You could hide the table by turning the hidden attribute of the properties
dialog box, but again this can be taken off again.

If you can modify the database you are accessing via the ODBC connection you
could create a view showing only the appropriate fields and link to that
rather than the table.

Rod Scoullar