The Access Show - Making Beautiful Access Web Applications

Download this episode

Download Video

Description

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:

 

Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      BrentMorris​RTP

      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

    • User profile image
      Johnny_B

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

    • User profile image
      Aravind

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

    • User profile image
      _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.
       
       

    • User profile image
      Alan Cossey

      Excellent video, excellent product.

    • User profile image
      raviRay

      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. 

      Regards

    • User profile image
      Joseph 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.

    • User profile image
      Ben 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.

    • User profile image
      Chris 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!

    • User profile image
      siddiqali

      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.

      Thanks,
      QUALITY COMMUNICATION PROVIDES
      QUALITY WORK
      Mohammad Siddiqali.

    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.