Hide store procedures from users

[eloise]

Hi

I have an access front end(xp) and SQL Server 2000 backend. I want to hide the store procedures (displayed as queries in access) from my users. Could anyone help.

Also how do I prevent the user from using special keys (shift , enter) to see behind the application. I have changed the application to an ADE file, but the users can still get to the backend. Thank you in advance

 

[thornmastr]

You can use Access security to control who can see and do what to your database.

There are, I think, FAQS in this newsgroup to show you how to block shift-enter from working. If you can’t find one, post back, and I will post the function I use to do this.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com