Outlook-Style Calendar Room Booking System using Access Services in Sharepoint 2010

Room Booking System using Access Services

With Access 2010, you can move your tables to SharePoint, and create end-user forms in Access that will show up in SharePoint as a special site. The MS Access 2010 web forms have a similar look and feel to normal SharePoint pages, and you will need to design your web forms in MS Access 2010 separately from any client forms you want to display to users when they view your database using Access on their own machine. The formal name for the feature is “Access Services,” but expect it to be replaced by something more descriptive and less “techie” in the years to come.

http://www.opengatesw.net/ms-access-tutorials/Access-2010/Microsoft-Access-2010-Access-Services-Overview.htm

http://curriersblog.spaces.live.com/blog/cns!1FE2EFF5F31CEDCA!449.entry

http://workerthread.wordpress.com/2010/01/16/thoughts-on-access-services-in-sharepoint-2010/

http://www.khamis.net/blog/Lists/Posts/Post.aspx?ID=4

http://jacksonc.wordpress.com/sharepoint-2010-vs-2007

A challenge for IT Pro’s in SharePoint 2010 is getting to grips with the deployment options that SharePoint 2010 brings, this article deals with two considerations:

. Physical Architecture
. Installation and Configuration

A successful SharePoint Design includes not only the deployment pieces but also other key architectural pieces such as the Information Architecture, Applications Services, Web applications and the collaboration structure.

Physical Architecture
64 bit requirements for SharePoint 2010 and SQL Ensures you have sufficient resources to power the products and a minimum 8GB of memory is however recommended for SharePoint and 16GB for SQL, it is recommended that SQL Server is on its own server and clustered or mirrored for high availability. A single server could support your concurrent connections but does not offer resilience however SharePoint’s topology is flexible so you can easily add additional servers and scale services across them. Adding application services can change a physical topology such as Performance Point which due to its workload could be dedicated its own SharePoint Server. With more SharePoint Servers you will need to ensure your SQL server has sufficient resources available, 64 bit enables SharePoint to handle more requests making SQL now work harder.

Installation and Configuration
Installing binaries is the easy bit although you do need to be aware of where you are locating certain files such as the SharePoint data folder which by default locates the Index flat file which can easily grow to 10% of your content crawled. You can also automate the installation and farm configuration process by using PowerShell and the PSconfig tool which gives you much more flexibility in defining your naming conventions and service account for central administration.

TechNet Deployment Guides
Scripted Install Guide
Planning for Capacity

Steve Smith is a SharePoint MVP and owner of Combined Knowledge which specialises in Global Education on all aspects of SharePoint including how to correctly build and deploy. Find out more.

More From pstilgoe

• Converting a Sharepoint List into XML
• Sharepoint 2010 – Sneak Preview
• Porting a SharePoint 2007 WSPBuilder solution to SharePoint 2010

When we decided to make our popular PDF Converter for SharePoint compatible with SharePoint 2010, we had no idea what we were in for. Will it be a nightmare, will it just work, will we need to throw everything away?…. we simply didn’t know. Fortunately SharePoint 2010 is much like SharePoint 2007 and as a result we released the SharePoint 2010 compatible version earlier today. Continued here….

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• Converting a Sharepoint List into XML
• How to embed a powerpoint presentation into a Sharepoint page

The Football Association (FA) has implemented a solution that will help it communicate better with English football clubs using Microsoft’s latest edition of its collaboration and content management platform SharePoint 2010.

The FA’s system was designed and implemented by consultancy and technology services firm Concentra, which has worked with the FA for four years and is a Microsoft SharePoint Gold Partner.

The FA wanted to improve efficiency and cut costs. It approached Concentra and asked the firm to provide support in selecting and using the latest edition of SharePoint.

“Concentra was crucial in identifying Microsoft SharePoint 2010 as the right solution for meeting the needs of the FA,” said Saty Gahir, enterprise content manager at the FA.

“The organisation worked closely with us to identify the value that it could deliver and, once the proof of concept was up and running, Concentra worked with our project team to help them fully get to grips with the solution,” he added.

Gahir claims that early indications from using SharePoint show that, for disciplinary cases, the FA estimates savings of up to 75 per cent in courier costs alone.

Goetz Boué, director at Concentra, added: “SharePoint 2010 builds on the benefits of the previous version and also adds a number of new features. We look forward to working closely with businesses in the future to help them realise its full potential and ultimately improve efficiency and cut costs.”

Source: computing.co.uk

More From pstilgoe

• Import data from CSV and SQL to a SharePoint list
• How to configure Kerberos for SharePoint / MOSS 2007
• Porting a SharePoint 2007 WSPBuilder solution to SharePoint 2010

Sharepoint 2010 RTM is to be released in April 2010.

The SharePoint 2010 official launch date is May 12th 2010.

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• SharePoint/MOSS Active Directory Self Service Web Part
• Sharepoint 2010 – Sneak Preview

I had a problem where external users, in this case hotmail addresses werent recieving Sharepoint Notifications. I was scratching my head but the solution was a simple one, as they normally are….

If you are going to let users outside of your domain receive outgoing email from SharePoint, you may need to enter their domains as valid in SMTP. To do this go to your SMTP server under IIS and right click on Domains. Choose New Domain, and Remote. Add the domain of your users’ email address. If it is going to be a mixed bag, you may need to add several remote domains such as *.com, *.net, *.org, *.co.uk etc etc

More From pstilgoe

• Sharepoint 2010 User Profile Synchronization Service stuck on starting
• How to Prevent users from changing views in Sharepoint
• How to uninstall Sharepoint templates

For anyone else having this issue it looks like this is an issue with the beta version of Sharepoint 2010 as when using service accounts it appears that the user profile sync just sticks on ‘Starting’ & never actually starts.

To get it started add your service account as a local admin & reboot & you should find it starts OK.

Good job its a beta in a test environment!

More From pstilgoe

• SharePoint/MOSS Active Directory Self Service Web Part
• This page cannot be edited in SharePoint Designer
• Need to edit a sharepoint page but there is no edit option

Sharepoint 2010 – Sneak Preview

http://sharepoint.microsoft.com/2010/Sneak_Peek/Pages/Overview-Video.aspx

More From pstilgoe

• Displaying the week number using a Sharepoint calculated column
• SharePoint/MOSS Active Directory Self Service Web Part
• Sharepoint Customising Search Series