Hide database objects in Access 2007 ADP

Question

 Using Access ADP 2007 form with connection to SQL Server 2008 Express

Currently users are able to see all of the objects in the SQL Server database when they open an Access ADP form I have created. The only thing I want them to see is the form when Access opens from a shortcut on their desktop. I already have it set up where the margins are collapsed and the ribbon is hidden, but they still insist on opening these items. Some have gone in and changed the design of the form. Please tell me how to hide all objects and keep them from making design changes.

Thanks

David

---

DR

Answer 1

This forum is for questions regarding apps for Office which are new in the Office 2013 Preview release.  You will likely have better luck in this forum.

Mike Morton - Senior Program Manager - Visual Studio

Answer 2

You can make it difficult, but not impossible. Before you go down that road, ask these users what they are trying to accomplish by making their own changes. Look at it as an opportunity to understand your users better and build a better app.

Access to SQL Server objects can be restricted by applying security at the SQL Server level. The objects would likely still be listed, but user wouldn't be able to open them. This is how most ISPs set up their shared database servers as well: I can see all 100 database objects, but I can access only one.

In the Office Key > Options > Current Database dialog you can restrict access to some Access features. These options can also be set in code. Careful! You can lock yourself out as well. Did I mention making a backup before you do this?

---

-Tom. Microsoft Access MVP