generate warning message when table accessed

[CAM]

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

 

[John Vinson]

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]

 

[CAM]

John, Thanks, Yes I did already restrict their access to the table. However,
since it is a table that some people previously had access to, I wanted to
have a special message telling them who to contact concerning those
particular data. I could send out a mass e-mail, but the reason I had to
suddenly restrict access is that there seem to be some major data errors in
the table and I don't want to draw uncessary attention to the person who's is
responsible for the data.

So, if anyone else knows a way to have a message specialized message pop-up
when someone tries to access a particular table, I'd appreciate it.
Otherwise, I'm sure they'll just be calling me anyway........... ; )

thanks,
Cheryl

 

[Pat Hartman\(MVP\)]

As John said, there isn't any way to do this. Displaying a message when a
table was accessed would require a trigger at the table level. Access/Jet
does not support triggers. Ergo, no can do.

 

[CAM]

OK,
Pat and John, thanks for taking the time to answer this for me.

Cheryl