Securing Append Query

[Guest]

Hi: I was just wondering how can I secure an append query. I don't want the
users to see the design of my append query.
I used the RWOP for other select queries
(http://msdn.microsoft.com/library/d...odeopg/html/deovrprotectingaccesssolution.asp)
but can't use this same technique with append query as I cannot write query
on append query. Any help in this regard would be much appreciated.
thanks

 

[Joan Wild]

You can do a lot to hide the db window, set custom menus/toolbars etc so
that the user can't get to the design of your append query, but I'm
wondering even if they did, all they can do is read it.

However, if you create a RWOP query for every table in your database, you
can then run the append in code.

INSERT INTO RWOPQuery SELECT ....