Category Archives: Tips & Tricks

Suppress Multiple Authentication Prompts when using Access 2013 Web Databases

Here is a short video that shows how to configure Internet Explorer so that hosted Access Web Databases do not require multiple logons to the SharePoint 2013 site collection. If you are getting repeated requests to logon to your SharePoint … Continue reading

Posted in Access 2013, Tips & Tricks, Video Tutorial | Leave a comment

Cross-Post from AccessExperts Blog

We have partnered with the Access Experts to offer our SQL 2012 Hosting Service. Check out this video tutorial on some advanced code techniques that would be compatible with our SQL or RDP hosting: Learn advanced techniques on Microsoft TempVars, … Continue reading

Posted in Tips & Tricks, Video Tutorial | Leave a comment

First Look at Access 15 / Access 2013′s Metro Design

When you first boot up the Access 15 Public Preview, you will be greeted with the option to create a blank web database, a blank desktop database or select one of the Desktop or Web templates that are available.  It … Continue reading

Posted in Tips & Tricks | Tagged , | 2 Comments

Introduction and Getting Started Video for RDP Hosting

This video introduces you to our Remote Desktop Hosting service. It shows you how easy it is to get started using RDP hosting with our free trial and how to easily copy/paste your local Access database up into the cloud. … Continue reading

Posted in Tips & Tricks, Video Tutorial | Tagged , , | Leave a comment

Moving Your Microsoft Access Database to the Cloud

AccessHosting.Com offers a number of different approaches for moving Access 2003, 2007 and 2010 databases off of your desktop or corporate network and onto the web. Moving your Access database to the cloud has wide ranging benefits including increased security, … Continue reading

Posted in Featured, Tips & Tricks | 2 Comments

Demystifying currentwebuser(x)

As many of you know currentwebuser(x) can be used inside your Access Web Database as follows: 0 gives current user’s member ID. 1 gives current user’s display name. 2 gives current user’s login name 3 gives current user’s e-mail address. … Continue reading

Posted in Featured, Tips & Tricks, Video Tutorial | Leave a comment

Screencast Organizer Template now on office.com

Great news – the screencast tutorial web database that we developed to help organize our Access 2010, SharePoint 2010 and Office 2010 tutorials has been accepted as a direct download from Microsoft. Access 2010 users can now go to the … Continue reading

Posted in Tips & Tricks | Leave a comment

Get an Access Database on the web in less than 5 minutes

How it Works When you publish a web database, Access Services creates a SharePoint site that contains the database. Every database you publish will have it’s own unique URL (i.e. demo.accesshosting.com/database1/). All of the database tables, forms, reports and queries … Continue reading

Posted in Tips & Tricks | Leave a comment

Charting inside Access Web Databases using SharePoint 2010

This tutorial walks through the process of creating an Access Web Database, connecting tables in that database to a SharePoint Chart Web Part, and then incorporating that chart back inside an Access 2010 Web Form:

Posted in Tips & Tricks, Video Tutorial | Leave a comment

How to Customize the Access 2010 Ribbon

This short tutorial video will teach you how to create a customized ribbon in Access 2010.  You can place all the commands that you use the most in one custom ribbon and save a lot of time and improve your … Continue reading

Posted in Subfeature, Tips & Tricks, Video Tutorial | Leave a comment

Access 2010 Tips: 5 Tips to increase Productivity

1. Get to Know the Ribbon If you skipped Office 2007 and are making the jump from Access 2003, the Microsoft’s Ribbon is a new feature and potential annoyance.  I know that when I first switched from Excel 2003 to … Continue reading

Posted in Subfeature, Tips & Tricks | 1 Comment

Access 2010: Interactive menu to ribbon guide

If you’re getting lost in Microsoft Access 2010′s Ribbon then this interactive reference guide is for you.  It will help you transition from Access 2003′s menu system to the Access 2010 ribbon.  It’s a visual, interactive reference guide to help … Continue reading

Posted in Subfeature, Tips & Tricks | Leave a comment

How to Create a Web Database from Excel

Lately we have gotten a lot of questions about how businesses can take their old access databases or excel spreadsheets and get them on the web with Access Hosting. The tutorial video above will hopefully demonstrate some of the issues … Continue reading

Posted in Subfeature, Tips & Tricks, Video Tutorial | Leave a comment

5 Reasons why Microsoft Access Schools Quickbase

Back in 1999, Intuit launched Quickbase – a web-based collaborative database application that allows business people to create their own custom applications without writing code. The application is hosted by Intuit and sold by subscription.  At the time, Quickbase had quite … Continue reading

Posted in Subfeature, Tips & Tricks | Leave a comment

How to Delete Your Published Access Web Database from SharePoint 2010

This short video will walk you through the steps necessary to remove a published database from SharePoint 2010. This process should be used with caution as the database, when removed completely, is no longer recoverable from the recycle bin.

Posted in FAQ, Subfeature, Tips & Tricks | 3 Comments

Where to download an evaluation copy of Access 2010

If you need an evaluation copy of Access 2010 to test alongside our Access Hosting service you can find it here.  Remember that Access 2010 is only included in the Office Professional 2010 Suite, NOT the Office Home or Office Student editions of … Continue reading

Posted in Subfeature, Tips & Tricks | Leave a comment

Demystifying the Access 2010 runtime client

The introduction of web based forms and reports in Access 2010 is a huge step forward for the product, but there are many scenarios which dictate that an application be developed natively in Access 2010. Fortunately, the Access 2010 runtime … Continue reading

Posted in Featured, Tips & Tricks | Leave a comment

Distribute Your Access 2010 Web Application with an ACCDW file

This short video will show you how to distribute your Access 2010 Web Application to other Access users by creating and ACCDW link. The ACCDW file is a small shortcut file that allows users to connect to your web database … Continue reading

Posted in Subfeature, Tips & Tricks, Video Tutorial | Leave a comment

Create an Access 2010 Table Using Copy/Paste

One quick and easy way to create a new table in your Access Web Database is to use the clipboard and copy/paste from Excel or any other tabular data source.

Posted in Subfeature, Tips & Tricks, Video Tutorial | Leave a comment

Delivering Email from Your Access 2010 Web Application

We recently published a short video tutorial on using data macros to trigger an email alert in Access 2010 (see below).  Since this behavior assumes that you are running on SharePoint 2010 Enterprise Edition and relying on SharePoint for email … Continue reading

Posted in Subfeature, Tips & Tricks, Video Tutorial | Leave a comment