View Complete Post
This article provides a first look at tools in Visual Studio 2010 designed to support development and deployment of SharePoint 2010 solutions. The article provides an example of designing and deploying a visual Web part.
MSDN Magazine October 2009
I posted a similar question in the Access Form and the MVP's there suggested I post a follow up here, to clarify the SharePoint issue.
My Question: is SharePoint and Access 2010 a good platform, or can it do what I need?
I currently have a client/server app built in Access 2002 with many clients in a single industry. My clients are very mobile and would like to be able to do their work in the app anywhere, not just while connected to the office network. Likewise, a large
percentage in that industry have Macs (I've used Windows in Parallels or Fusion for these clients but it's not a smooth process, in a lot of 'connectivity' ways). My clients are asking, and my competition already has, web based applications. I very much need
to get my app on the web. Along with that, I need to set it up as a monthly subscription based application.
So I'm hoping Access and SharePoint can do this. I don't know ASP or PHP or SQL so it'd be a steep learning curve if I have to go that route. I don't know much about SharePoint but have watched videos about using it for Access Web databases as well as RichClient/SharePoint
It's possible I could have over 1000 clients, each of which will have a few thousand records in the main few tables (SP Lists). Each client could also have several users l
I was able to install and configure SP 2010 Foundation on a Windows 7 Home Premium Edition as a Development Environment. But I am facing following issues:
a)cannot export lists from Access DB (Reason not able to connect to the local site on my machine)
b) for a list on SP site can't "Open with Access" - Access application is triggered, but the list doesn't show-up.
c) open a Page or List for edit with Sharepoint Designer ( SharePoint Designer application gets triggered but it get message "Unable to open Web site, Possible Causes: ..."
d) Also "Open Site" for local site on my machine gives the same error as in point c) above.
These 4 unsuccessful operations happen only for the local development site (created on my laptop), all the above operations are successful though when I do them on a web hosted SP 2010 site. I have given "Full Control"
permission for my login on the Central Administration. So what is wrong with the local site which prevents SharePoint Designer and Access DB connectivity?