You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Microsoft has an internal classified ads Web site that allows employees to buy and sell stuff—think of it as a company Craigslist. Barath Balasubramanian a tester on the Access team decided to recreate the app using Access 2010. I asked Barath to join us on The Access Show for a short demo. He plans to share it on Office Online once we ship Access 2010 (it will automatically show up inside the Access’ BackStage New page). In the meantime Barath has shared a beta copy on UtterAccess.
Subscribe to The Access Show: RSS, iPod/MP4, WMV (high quality), Zune, MP3
Hopefully, it inspires some of you with new ideas for the contest.
Interesting post sounds like a great idea good read.
How did you go about authorization and authentication on the web? Noticed you edited 'my ads' but there was no login (app knew it was you as your name was in the header).
Where did you publish this? Do we need SharePoint 2010 for this? OR IIS is sufficient?
Thank a lot! Can I test it?
Great app. Just curious if your SharePoint server is customized to disable the top menu bar for some users so that they can't download and edit the web database file. Or is it open for everyone to download and edit. I read somewhere it is a fairly deep configuration setting to hide the option on SharePoint.
>OR IIS is sufficient? In the case of access, you need SharePoint. On the other hand, if you develop in any web based system, you need a LOT more then just a web server with something like IIS. This database stuff is not just an simple HTML web page. Typically for web development you need to install + setup + learn some type of database SERVER system. You have to spend a good deal of time setting up and learning how to run that server database system (and the database programming language). You also then need to learn a programming language and scripting system for things like the browser side code. So simply having an web server like IIS or Apache is not near enough when you toss in the database part. That where the complexity shoots through the roof. (the database parts force you to build complex connection strings to stitch up web server and browser to the database server). This increases complexity of your applications. Access does all of the above behind the scenes for you. At the end of the day, this system is not really different then any other web based development system. If you build your application around IIS + MySql, but your web system uses oracle or sql-server, then your application will not work without significant re-engineering. You always had to match up your web server system to that of the development tools you plan to use (access is no different). In most cases you thus learn several programming systems and deal with several types of servers (database server, web server, web programming system (the middle teir). Access is nice since you can start web development on your desktop without installing or even having a database server running on your computer (you don't need a web server running either). You could be sitting on a beach somewhere under the sun without any internet. So without database or web server running you can test + create + run + try out your web forms you are developing. Of course after you publish then all of the separate complex technologies are stitched together for you automatically. So connecting the web server (IIS) and database system and forms code (java) is is all done for you. Most important here is you don't need to learn 3-4 separate systems). You can think of your web development stack requirement as being SharePoint. What is very different compared to other web systems is that you can build, test, run and develop your project without any server parts at all, but just use the simple little desktop database system called ms-access that you used for years. Albert D. Kallal
Edmonton, Alberta Canada
Smart stuff, Barath. I notice that it uses CurrentWebUser to determine which are "my" classified apps. Will there be any information on this coming out any time soon. I note that CurrentWebUser can be used in VBA and has an argument of enum acWebUserDisplay (acWebUserEMail, acWebUserID, acWebUserLoginName or acWebUserName) and that there are functions CurrentWebUserGroups (enum acWebUserGroupsDisplay, i.e. acWebUserGroupID and acWebUserGroupName) and IsCurrentWebUserInGroup (which seems to take a variant as its argument). The reason I ask is because, though the Access team have, not surprisingly, majored on the creation of web pages using Access 2010 (and which is truly excellent), I can see Access 2010 being used big time with a .accdb front end file with the data in Sharepoint 2010. To do this, it would be a big help to understand the functions I mentioned (at least I think so).
Nice job, Barath and Clint. This is a great example of an Access app running smoothly in the browser. Nice touch on mentioning Safari and Firefox! But what happened to Chrome? Just kidding, I know it will run there too. :) I'm really looking forward to exploring how Access 2010 web applications will work for our client projects. I see it as a way to deliver web apps where ASP.NET development costs aren't justified. Armen Stein
J Street Technology, Inc.