The Access Show - Making Beautiful Access Web Applications

Sign in to queue

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

Download

Download this episode

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.

Add Your 2 Cents