Is there a simple way to check one's own access privileges for a table.
I've got an app (accessed via the web with PHP and ODBC via MSAccess) and
want to display different fields on output screens depending on whether the
current user has update or read-only access. I can think of all sorts of
(scary) techniques for doing this - like attempting a dummy update at the
start of the form load (pretty inefficient) or giving "update" users access
to the mysql DB so they can check security directly via the User table
(dangerous).
There's gotta be a simpler way:-))
Mick