In the last post, I described how you can publish an Access database to SharePoint. This time, we'll look at taking that database back offline, making data changes while disconnected, and re-synching. I'll also briefly discuss updating the thin client version of the application using SharePoint Designer. Opening the Application from SharePoint When the database is published to SharePoint, it moves the data into WSS lists and the database front-end into a document library as described in the last...

Albert D. Kallal (Access MVP) has published a great video demo of an application that he build for tracking meetings rooms . He even has built a fancy calendar control that renders in the web using data macros and bound controls. it is a good example of the types of things you can do in the browser with Access + Access Services. Here is my favorite quote from the video: I find this new table level programming model encourages designs that allow you to quickly react to your changing business needs...

Today’s guest writer is Ric Lewis—the PM in charge of publishing to SharePoint. A common question in the Access community is “how do I get my app on the web?” Here is the most recent example : My wife and I have just started our own Recruitment business and I started an Access DB to basically be a contact manager and to track our jobs, candidates, clients and placements we make. I got to a certain point and realized I was out of my depth, so I enlisted the help of an Access...

One of our goals with Access 2010 was to make it easier to reuse your database design work. In the Access 2007 Developer Extensions, we allow you to save a database as a template, making it available for others to use either as a starting point or a ready-to-use application. In Access 2010, you now can also save the database or a collections of fields as a new kind of template— a part. Application Parts An application part is an Access template that you can add to an existing database, to extend...

Up to this point, I've discussed building traditional Access client-side databases and run through some of the new tools and techniques that are available. This represents a very important part of the work done in Access 2007, but it is only one part. In addition, we've done a lot of work to make it easy to build client-server databases against Windows SharePoint Services. Doing this allows users who don't have the skills or privileges to be SQL Server DBAs to still get the manageability and stability...

I was looking for this in search results today and realized that it isn't showing up in the rankings (or maybe it does, but the name isn't very intuitive). The new Access 2007 database engine (which reads and writes .accdb files) is available in redistributable format for those who need to code against the file directly, bypassing Access/VBA.

Access 2013 web apps feature a new, deep integration with SQL Server and SQL Azure. In Access 2010, when you created a web application on SharePoint, the tables in your database were stored as SharePoint lists on the site that housed the application. When you use Access 2013 to create a web app on SharePoint, Access Services will create a SQL Server or SQL Azure database that houses all of your Access objects. This new architecture increases performance and scalability; it also opens up new opportunities for SQL developers to extend and work with the data in Access apps.

...

This post comes from Russell Sinclair who is in New Orleans showing off the newest Access 2010 features at TechEd. Microsoft SQL Azure is a new cloud-based relational database built on SQL Server that provides highly available, scalable, multi-tenant database services hosted by Microsoft in the cloud. It eliminates the need to install, setup and manage SQL Server, freeing IT to handle day-to-day operations rather than having to manage and maintain an on-premise server. It also enables access to the...

How do you wrap text in Access? It's a question we hear quite frequently on Office.com. It may surprise you to learn that in most places where text is displayed in Access, text wrapping is on by default. The key is making sure there is enough room for the text to wrap.

...

Last week we blogged about changes to the new macro designer . I promised to write about IntelliSense but the first draft was lost in an unfortunate hard drive crash. I thought this is a good time to tell you about changes to the macro designer that encourage good design through better support of parameters. A good database design requires developers to think performance and scalability upfront. Query parameters are often used to improve database performance because it forces application developers...