Re: Use of Sharepoint 2010 and Access 2010 - Interesting answers regarding Security and who can make changes

Albert D. Kallal wrote:
"Bob Alston" <bobalston9@xxxxxxxxx> wrote in message
news:ag62n.3754$%P5.2195@xxxxxxxxxxxxxxx
Take a look at this thread for answers to verious questions about security
settings for users accessing an Access 2010 app to download to their PC
and run under Access/windows.

http://social.technet.microsoft.com/Forums/en-US/sharepoint2010general/thread/13a3b9c0-3fb9-4ff0-b725-145d5e482473?prof=required

Note that with this setup, you cannot have the equivalent of an MDE

(note: I using the term mdb and mde here for clarity, but in fact we talking about an accDE and an accDB).


Why not just publish an mde then ?

I mean, if you going to publish a mdb file for distribution, then you have an mdb file and that is your intention. I think for what, about 18 years of ms-access an mdb file are able to be modified by users. Why would you expect this to change? For what reason?

You can certainly publish an mde file to access services, and the resulting download can not be modified by the end users. (well, no more or less then mde always been). However we talking about VBA forms that are linked to SharePoint tables here.

I mean is quite simple that an published mdb is going to be modifiable by users as that is how they always worked.

Now, I not played much with testing and publishing mde files. However, you can publish them and the end results are NOT able to be modified by end users. I think the "gray" question here would be how to send out new modifications using this approach? I have not played with this idea much, but you could likely import new forms from the non published mde (accde). We just have to play with this a bit more.

On the other hand, you can always distribute an NON published accDE file that has the tables linked to SharePoint. It is a question if you want or ARE going to use *web* services for the distribution or not. You don't HAVE to use published web services application for distribution methods here. You can just distribute the mde file to your end users.

As I see this now, the only trick or question is how to get new forms etc. into that mde that has been published to web services.

Perhaps one has an design master that we import those forms from, I just not played with this enough to figure out what approaches will work.

However, at the end of the day, you still have the option to distribute an mde to users that has tables on SharePoint.

For years, I had an built in web based update system into my software, and who knows, I likely continue to use that method. On the other hand, if you talking users in 100% browser based, then they not running ms-access local, and they don't even need ms-access installed in that case..

I am focusing on the capabilities of Access 2010 and Powerpoint 2010. clearly using Powerpoint 2007 one can publish any document, *.mde or *.accde and allow others to download it. And apparently *.accde can access data found on an Sharepoint 2010 server. But I have not read anything about how they can work in the spirit of the new 2010 capabilities - allowing updates to be automatically refreshed.

My focus continues to be on the new capabilities which allow
1) geographically separated users to use a common data source, the Sharepoint 2010 server
2) The ability to use sharepoint 2010 server to a) download the app and b) automatically update the app.

I would enjoy hearing from others who are testing out the Access/sharepoint 2010 capabilities to do these things.
.

Relevant Pages

  • Re: Use of Sharepoint 2010 and Access 2010 - Interesting answers regarding Security and who can
    ... you cannot have the equivalent of an MDE ... I mean, if you going to publish a mdb file for distribution, then you have ... I not played much with testing and publishing mde files. ... to use published web services application for distribution methods here. ...
    (comp.databases.ms-access)
  • Re: Vista 64bit rpeventing file copy
    ... file, via email or download, it appears as though the file has copied ... The original install program installs the Access runtime, ... contains a new MDE. ... directory entry and leave the original file as free disk space. ...
    (microsoft.public.windows.vista.security)
  • Re: Internet download
    ... you've got a file with an extension of mde on your website, ... users download it, the file they download has an extension of mdb? ... no easy way to convert an mde back to an mdb, ...
    (microsoft.public.access.security)
  • Re: Access 2010 article
    ... Is there an option when users download the Access front end app from sharepoint to effectively make it an MDE version - so they cannot see nor change the forms, ...
    (comp.databases.ms-access)
  • Re: open db without access
    ... Which version of Access is the .MDE created in? ... you can download a Runtime version from Microsoft at no charge. ... Microsoft Office/Accesss MVP ...
    (microsoft.public.access.formscoding)