Access 2010: Outlook-Style Calendar in Browser, by Albert Kallal (cc)
Why Stack Overflow recommends it
Stack Overflow users link it when answering questions about publishing Access 2010 apps to the web, since it shows an Access application running 100% in a browser.
Recommended by 3 people across 11 different months, 2009 to 2023.
What it is
A short 2009 demo by Microsoft Access MVP Albert Kallal, posted on Crystal's Access channel. It shows Access 2010 web publishing, including an Outlook-style calendar, with the app switched to run entirely in a web browser at the halfway point. The description also covers the Navigation Control, Web Control, Picture Control and data macros.
What people said
Recommends Alex Gordon · 2010-09 · Stack Overflow · on “how do i build a website using access 2010?”
has anyone done this yet? please show me some good tutorials on building websites with databases using ACCESS 2010 you can build a website using it: [this video]
Recommends Albert D. Kallal · 2010-09 · Stack Overflow · on “access forms as asp.net's listview”
Access can actually create .net forms when you use access 2010. (the forms are real xaml or so called zammel forms). The beauty of this system is you get to keep the same point and click approach that allows you to build master forms with child sub-forms. You not have to write one line of code and you not ever see one connection string. Only downside of this great new system called "Access Web Services" is it requires SharePoint (enterprise). So, this is a true access development for the web, but you continue to use the Access client to build those forms. Those forms scale out to many users since you using xaml forms and SharePoint. Here is a video of this in action: [this video] At the half way
Recommends Fionnuala · 2011-02 · Stack Overflow · on “Microsoft Access as web DB”
You can use Access 2010 to build websites with Sharepoint: [this video] Otherwise, it is unlikely to be a good idea, unless you are thinking of a private website, it which case it is do-able, with care, but still, not necessarily a good idea. This document contains an interesting table of limitations etc [LINK]
Recommends Albert D. Kallal · 2011-02 · Stack Overflow · on “microsoft access to web pages”
New for Access 2010 is the ability to build web sites. If you look at the following video, note how at the half way point, I switch to running the Access application 100% in a web browser. [this video] There several things to keep in mind when building web forms with Access 2010. The forms cannot have VBA, but must use macro code. This macro code is converted into JavaScript and does run inside of the browser. The resulting forms are standard .net XAML (zammel) forms. Server side code is possbile with writing data macros. The Access reports you publish to the web are rendered` using SQL server reporting services. To use Access web services you need SharePoint or wait until office 365 comes out wh
Recommends Albert D. Kallal · 2012-01 · Stack Overflow · on “android and ms access”
Consier building a 100% web based with Access. New for Access 2010 is the ability to create web based applications. You can then publish that application and forms to SharePoint or even the low cost office 365 (starts at $6 per month, and you can hang more then one user off that account). You then just have the phone hit the web site. I am doing that now with my windows 7 phone and the Access screens look like this: and (above is from the wp7 emulator, but they look identical on my phone). All of the buttons, style etc. was built only using Access on my desktop. I then hit publish, and then the forms + code etc. goes up to the cloud. Note that code you write in a Access form when published t
Recommends Albert D. Kallal · 2012-02 · Stack Overflow · on “Creating a web application with android that connects to a Microsoft Access database”
You could consider Access web services. This would mean that you publish your database to SharePoint or now office 365. That published data becomes useable via a web service and as such would work well in disconnected mode that is typical required of a smartphone application. The Access desktop/client application can also link to this published data (and application). And the application functions in disconnected mode. So if you lose your connection then the application continues to run on the desktop clients. Here is a video of me running an Access application and I switch to running this application in a browser at the half way point: [this video] (no ActiveX or Silverlight is required – you ca
Recommends Albert D. Kallal · 2012-03 · Stack Overflow · on “Something like MS Access, but in the cloud”
A possible consideration is to continue to use access. Access 2010 now has web publishing, and you can publish Access applications to office 365 or SharePoint. The great thing about this system is Access Web Services retains and keeps the rapid application development paradigm that Access is so famous for. You don't have VBA in web forms, but all the classic features such as continuous forms, sub forms, and opening forms with a where clause to filter form all exist in the new macro programming language. Take a look of the following video of mine running where I built a room booking application built with Access 2010. Notice how at the halfway Point I switch to run in the application 100% ins
Recommends Albert D. Kallal · 2012-06 · Stack Overflow · on “Using MS-ACCESS split database over internet”
You can check out my article here: [LINK] In the above I explain your options. I mean, if you have a server anyplace (as you plan), then I see little reason to not use a free edition of SQL server for the back end. Also, I not sure why you think some technologies like using SharePoint or office 365 (cloud) are expensive? The basic edition of SharePoint is free with any server edition of windows (2008 R2 last time I looked was under $500). And you can get office 365 plans staring at $6 that supports not only you placing your data tables in the cloud and linking your MS Access VBA front end to those tables on o365, but for that same low price you ALSO can create web forms in Access and publish
Recommends Albert D. Kallal · 2012-07 · Stack Overflow · on “How do I display Access 2010 forms within an ASP.NET Application?”
If you talking about Access 2010, then web forms created with A2010 are in fact standard .net forms and they are based on zammel (XAML). So no conversion of any type is required for these forms. However, these web forms do require what is called Access Web Services. They can even be opended with VS - but this is much rife with the standard pitfalls of a 4GL system. Access web services currently are available from some hosting providers such as [LINK] You can also publish Access web forms to SharePoint 2010 (Enterprise edition). Last but not least, you can also publish Access Web forms to office 365 which is VERY low cost hosting that starts are $6 per month. The only real issue with these Ac
Recommends Albert D. Kallal · 2012-07 · Stack Overflow · on “How well can a MS Access form be themed?”
Access 2010 supports themes and in fact behind the scenes they are based on CSS style sheets. So Access 2010 the forms and buttons etc. can be fully "web looking" and that includes hover effects. In fact you can even export the SharePoint web site theme, and import it into Access now. (I don't know if you can edit the sheets directly - but you should be able to). Here are some of the design surface options: So an Access form now looks like this: Note the new "web" navigation control on the left side. While you can place plane Jane buttons on that form, you can as noted place round buttons, oval, and set the hover effects along with a shadow effect. So how much "web like" you want is certainl