Tag Archives: Access; Webdatabases

Access Webdatabases New Kid On The Block

Access Webdatabase

The Access Webdatabase functionality came available with the release of Office 2010. Wow finally we can create databases for the web was my initial thought. It did not take long to realize that this was a wrong assumption. One of the prerequisites was SharePoint 2010 – Access Services. Hmm i did not have SharePoint on my pc so i was not able to build my first web database. Sure there were third parties offering hosted environments to create Access Webdatabases but i registered to late to take advantage of their free offer. After a certain period you had to pay for their services. I asked my company if it was possible to use some space in our SharePoint environment to play around with Access Services. They agreed and i was able to build my first webdatabase.

A new learning curve
I soon discovered that creating webdatabases is a whole new experience. The embedded macro, the macro editor, the switchboard everything i almost never used in my Access development became important. What? Why would you want to do it like that when you can do it like this… everytime this question popped up in my mind when creating my database. During that process i forgot one major part and that was Access Services (on SharePoint 2010). It was not that Access could not do it the way i wanted it but it was SharePoint restricting me constantly. I decided to start all over again and tried to find out what could be done instead of what i would like. First steps: create a table and record validation. In this blogpost i will write about creating a table for a webdatabase. In future post i will write about the process of creating a simple webdatabase for SharePoint. So if you have the possibility join me in this adventure of creating a table for a webdatabase to publish later.

Continue reading

Access 2010 Inside Out

The inside out series goes in depth with features not used very often in the various applications. Sure you will read about the formatting and templates, cool etc but the real added value is in the chapters where you might think “hmmm never used that functionality before”. Access 2010 by Jeff Conrad and John Viescas is no exception. A wealth of information coming your way when reading this book. My personal interest went straight to the chapters about the webdatabase functionality. So if your are looking for a readable and well explained book about Access this is it.

 Want to take a sneakpreview first? Take a look at the bookreview on the MS Press blog here and take a deeper look at chapter 11: Modifying Data With Action Queries