Restrict processing to a table 1

[trudye10]

Heey Guys, I have a question.

A table in one of our databases is getting updated. We have no idea whose doing it (naturally everyone feigns ignorance), but it's not being updated in the program the table resides in, and the table is not linked to another database. Someone maybe updating it from another database because it is accessed via other database(s) that we don't have access to (but that's another story).

Is there a way to restrict processing against this table. For instance; allow reading but no updates or appends outside the database that houses it?

I hope that made sense,
Thanx much,
Trudye

 

[Remou]

Have you considered Access security?

 

[trudye10]

Remou, thanx so much for responding. What specifically in the Security Pkg would cover my needs?

 

[Remou]

Access security will allow you to restrict permissions:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

 

[trudye10]

Thanx so much, it appears the suggested link has a lot of good information.

Be well,
Trudye