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.
For all those that want to experience development with Access 2010, a new Access 2010 unit has been added to the Channel 9 Learning Center for Office 2010.
The new Building Solutions with Access 2010 Lab consists of 5 exercises highlighting the new web database feature and touches on the new Macro Designer and Data Macros. The new Macro Designer provides developers with a much easier and efficient environment to work in and Data Macros are similar to triggers in SQL Server. Rather than embed business logic throughout forms, one can associate Data Macros with tables so that anytime a user updates a table, the business logic executes at the appropriate time. And web databases, via Access Services in SharePoint 2010, can be published to the web whether the SharePoint site is on premises or hosted. The lab exercises step you through the process of building a web compatible database. If you have a SharePoint 2010 site, you can publish to it. Otherwise, you can take advantage of a free trial offer and publish your web database to accesshosting.com.
The hands-on lab exercises are:
Enjoy!
Comments: (7) Collapse
Great. I am so pleased with Access 2010. Thank you for making it so easy for us to create web application. Could you extend Sharepoint local table cache feature to other databases like SQL Server, Oracle or MySQL in the next version of Accesss? It will make Access even more popular in the years to come.
Tim--glad you like 2010. There certainly are lots of possibilities in this area.
Hi, unfortunately, the channel-links do not work.
I would be interested in knowing how many records can be published performantly in SharePoint lists/Access services.
Thank you - I'm excited to go do the tutorials. I am already developing desktop apps in it and loving it. Hope to use the web forms soon.
Since leaving accesshosting.com offering in January I signed up for practices with Access 2010 and until now I have not got the notification of my Free Trial account. I think this is a problem for Access developers have practices of new utilities. Why not create limited accounts microsoft SharePoint 2010? Every time I enter this blog, I'm sad because I can not use most of the updates do not have Access 2010 on account of SharePoint 2010 and I think most visitors will feel the same. Thanks for listening.
Ceac @ sorry you haven't heard back from Access Hosting. Send us your email address using email link above and I will put you in contact with the right folks to get you going with Access Hosting. I hear you about making SharePoint 2010 widely available. People here are working very hard to make that happen some time after RTM. Please be patience with us. :-). There is just lots of work to do to make sure we have the hosting infrastructure in place to scale to the expected demand.
I'm cross-posting this question from the exercises on Channel 9 here in case it's able to reach the Access development team in a more timely fashion: In Exercise 4: Creating a Data Macro
-> Task 1 – Create a Macro to limit Offers Outstanding,
-> 13. For the Where Condition, enter [Status]="Offer Outstanding" and [Contacts].[Position]=[Position] and [Contacts].[ID]<>[ID] - the condition is true when there is an outstanding offer on the same position for a different applicant. From what I can gather, unqualified fields in the LookupRecord block refer to the record in the [Contacts] table that is being looked up, whereas the [Contacts].* fields refers to the record being edited. Is this correct? I do find this confusing - what rules can I use to determine what entity is being referred to when if a field name is unreferenced (eg. in the first line "If [Status]="Offer Outstanding", or "[Status]="Offer Outstanding" within the LookupRecord block) or when a field name is referenced (eg. "[Contacts].[Position]" within the LookupRecord block)? I also noticed that the expression builder cannot build the unreferenced fields [Status], [Position] or [ID] in the where condition of the LookupRecord block, whereas it can build these fields within the If block. This is confusing as an experienced VBA developer in previous versions of Microsoft Access who has been told in the Access Blog to use to the new expression builder in Access 2010 to ensure I'm writing expressions that are compatible with web databases. Microsoft's feedback regarding this issue for the final release of Access 2010 appreciated. Kind regards,
Dave.
Comments: (loading) Collapse