Re: generate warning message when table accessed
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
On Fri, 20 Jan 2006 13:14:02 -0800, CAM
<CAM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>Is there any way to generate a warning message when a user tries to open a
>table, either directly or through some query that they might have only on
>their frontend?
>
>thanks,
>Cheryl
Nope.
You can use Access Security to deny them access to the table, either
design-mode rights, modify rights, read rights, or any combination of
these. But AFAIK there's no way to trap them attempting to *use* the
table, if they have the rights to do so.
John W. Vinson[MVP]
.
Relevant Pages
- Re: Why are all access database I open asking for log on?
... I, of course, am campaigning for using Access security. ... is, that even though I have been writing Access Apps for 7 years, I ... Admin and Users from all rights. ... (microsoft.public.access.security) - Security at an object instance
... I'm looking for advice on how to apply access security for an instance of an ... Using roles I can define that a user has the rights to perform a certain ... Any ideas/resources on how to do this in .NET. ... (microsoft.public.dotnet.security) - Re: Database query performance
... This posting is provided "AS IS" with no warranties, and confers no rights. ... Indexing of DateTime column does not ... >> To see how the server is handling the query, you can turn on the query ... >> Please reply only to the newsgroup so that others can benefit. ... (microsoft.public.dotnet.framework.adonet) - Re: WMI slow?
... Use this query instead and I tested it against Win2k on up and it works ... select * from __instanceCreationEvent where targetInstance isa ... This posting is provided "As Is" with no warranties, and confers no rights. ... > Use of included script samples are subject to the terms specified at ... (microsoft.public.win32.programmer.wmi) - Re: Help:No select permission, when implementing row-restriction in SQLserv2k
... It seems that if you have granted rights to the underlying tables that the ... The first thing to double check is the security, ... DENY SELECT ON dbo.TeilnehmerdatenNEU TO YourUserGroup ... > My test query statement in QueryAnalyzer(logged like IM1- ... (microsoft.public.sqlserver.security) |
|