Loading user information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading user information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

The Access Show - Making Beautiful Access Web Applications

5 minutes, 7 seconds


Right click “Save as…”

We know what Steve Ballmer wanted for Valentine’s Day! In this episode, learn about AccessLove, an Access Web Database application built by three Access team members, as well as a few tips and tricks for making beautiful Access web applications.

For more information about Access Web Databases, check out the following links or download the AccessLove here:


Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation
  • Brent MorrisBrentMorris​RTP Living the Dream

    Nice Video - however, I wish that the Access "parts" would have had more detailed comments. A "before" , "during" & "final" set of screen shots would have been helpful. A type of 101 on the Access "parts" would have added a better "understanding" to the Channel 9 viewer of "why" the final resulting app is so Cool. Feel free to do a 2.0 of this episode.


    Congrats again on the topic,

    Brent Morris

    Raleigh NC USA

  • What versions are you using? It will be about 10 years before we get the latest versions used in the mainstream!!

  • AravindAravind

    AFAIK this was done fully using Access 2010 which has been out for a while now!

  • _ivan_ivan

    I am sorry, but I can't help it but to voice some of the valid points:
    - How well will SharePoint lists handle over 1 mln records - How would you wrap changes to multiple related records into a transaction whith the ability to rollback if any server validations fail. - It looks like it is targeted for a departmental use by non-programmers. Which usually don't have any access to modify SharePoint sites. - Still many non-programmers will have difficulty understanding macros and a little code. - it looks like concurrency is handled by SharePoint Server, what if SQL is a back end. Access is notorious for transferring data first and then filtering it using WHERE clause, which affects performance on large apps.
    As oppose to making non-developers think they can develop a good quality app, Microsoft should rather add more developer features into Access, which they have not done for a long time :(.
    I would put more effort into Microsoft LightSwitch sounds like a more promising platform and/or at least change Access Jet Engine to SQL Express and VBA to VB.NET.

  • Alan CosseyAlan Cossey

    Excellent video, excellent product.

  • Guys, this is a really laughable Application. Absolutly kids toys. Access 2000 was a good Product. It is really sad to see the  "ideas" wich MS hat built the last 10 years. 

    Features nobody asked, and nobody use. Look at the forums ... 

    All professional Developers i can remommend to leave the shining access ship. And my recommend for the new target group "housewifes": Download Access, Buy it and build great new "valentinsday" apps. 


  • Joseph BolandJoseph Boland

    A lovely example of using Access services to support an engagingly interactive SharePoint site. Some of the comments above seem misguided. Access probably wouldn't support million record tables, so yeah, don't try to use it in such scenarios (don't use a hammer to cut butter or drive to work in a tank). And frankly, there's nothing laughable about porting an RDBMS into a web CMS, a very different accomplishment from supporting data connections; are there other examples of this? It certainly extends the usage scenarios for Access.

  • Ben McMannBen McMann

    This was great work. A very creative way to introduce an idea management solution into a company, or department within a company. If used in a proper context, it provides a low cost, quick solution to engage employees within a company. After releasing it and measuring interest, you can then justify a business case for an application that can handle enterprise-level demands. But quite frankly at first glance, the majority of mid-market clients I work with could utilize this as their solution. I will be investigating this more in-depth to see what other capabilities and features we can utilize with SharePoint to add more capabilities.

  • Chris QuickChris Quick

    This is a very creative use of SharePoint and Access Services. Upon seeing this, I immediately started thinking of ways to use solutions built in Access and leveraging Access Services for my clients.

    Access is a business tool that enables non-IT professionals to quickly build simple solutions to solve day-to-day problems. Applied correctly and in the proper context, information workers become empowered to solve daily challenges that used to require the interaction of the IT department. In my opinion, this is a shining example of what empowered information workers can achieve with the proper resources!

    I also agree with Ben McMann, using solutions like this can help business users clarify their requirements before jumping into an enterprise solution or development project. Using Access with Access Services will allow them to refine their requirements and measure usefulness of the application.

    Great job to Erika, Kerry and Barath -- thank you for sharing this resource!

  • siddiqalisiddiqali

    Hi ,
    I use access 2010 web macros.When i attach the access file to sharepoint which having macros coding in it,Then it works very slow.Any solution for this please send me to this mail.

    Mohammad Siddiqali.

Remove this comment

Remove this thread


Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.