Daily Access Tips

I was involved with the Microsoft Access 2010 first non-public beta.  A non-disclosure agreement prevented me from discussing details but now there is a public version available.  This should not be placed on a production machine and also not on a machine having earlier versions of Access you need to use.  This version has the ability to publish an Access application to the web using “Sharepoint Access Services”.  I have heard from various sources that any time from March to June 2010 will be the first release.

Below are several references* so you can find out more about what is being released.

• *New features of Access 2010 – http://www.microsoft.com/office/2010/en/access/default.aspx
  

• *Sharepoint 2010 and Access 2010. http://www.youtube.com/watch?v=Dq-tDuPfgZc
  

• *Microsoft Office Access 2010 http://www.youtube.com/watch?v=P8cheNlRlh4
  

• *Microsoft Access 2010 Macro Designer http://www.youtube.com/watch?v=6zvbK9×8rGw
  

• *Design navigation UI with Access 2010 http://www.youtube.com/watch?v=vkMzkhVfK6Y
  

• *Access 2010 Layouts http://www.youtube.com/watch?v=1wtgk2nosJE
  

• *Access 2010 data macros http://www.youtube.com/watch?v=J3G0ivjpy9k
  

• *Microsoft office 2010- Access http://www.youtube.com/watch?v=qUsrAJ6B_D4

If you are planning to use the new Access Web Forms, you will want to learn the new macros that will be needed.  Any forms that will run in an internet browser, after publishing to Sharepoint, will not use VBA code and will only use Macros. These forms and reports will also require the form and report “Layouts” that you now find in Access 2007.

The new data macros and lookups will allow much of your business logic to reside on the back end data side where you can make changes inside a single central location.

If you simply want your end users to work in the Access program but have the data reside on a Sharepoint server, you may use all the forms and reports and VBA code you have developed, but still have the great advantage of using the internet as your “extremely wide area network” for sharing your Microsoft Access database data.  In this case, just publishing your Access tables to an internet Sharepoint server will do the trick.

Microsoft Online Services:  http://www.microsoft.com/online/support.mspx will have this hosting available next year.  Currently they are only charging about $6.00 a month for single person licenses for their other Sharepoint services now currently available.  We can only hope it will be that inexpensive when they offer “Access Sharepoint Services”.

Bob Heifler