By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,551 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

Link To Selected Fields

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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" <sp**@nospam.spam> wrote in message
news:z7****************@newsread1.news.atl.earthli nk.net...
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

Nov 12 '05 #2

P: n/a
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" <sp**@nospam.spam> wrote in message
news:z7****************@newsread1.news.atl.earthli nk.net...
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

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.