I am working with an accdb Microsoft Access database that is going to
posted to a SharePoint server via Access Services. Everything I have
is web compatible, but I want to restrict what users can see. I want
to prevent them from seeing the design view of my queries, or even the
queries altogether, and the vba code used to automate my database.

Is there any way I can do that using Microsoft Access 2007-2010
without converting the database to accde or accdr, which isnt
supported by Access Services?

"Ryan Cunard" wrote in message
news:5007831e-060c-4a05-b3ca-f9a0186d214b (AT) cs7g2000vbb (DOT) googlegroups.com...

Are you asking to "remove" the ability for uses to download a local copy?
You can most certainly do this by setting correct permissions.

However, if you DO allow downloading of a local copy, then I don't believe
you can prevent end user modification.

You can also remove the top most SharePoint bar from your forms, but again
that is a different question (this would hide the option to download Access,
but in theory not prevent a savvy user who knows the "URL" to type in).

So it not clear if you looking to prevent local modifications or not. You
can certainly create a accDE that has vba forms and has linked tables to
those published web tables on SharePoint.

So it is much a question of what you are trying to prevent here. (no
modifying to local copy, or no downloading).

As noted, if you DO allow downloading of published web app then you cannot
prevent user changes.

However, as noted you can disable this download ability. If you looking for
a local copy for users without modifications allowed, then you could/would
in theory distribute a accDE and not the published web version.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com