Category Archives: Access 2013

How to add users to your Access 2013 Web Database


Here’s a video demonstrating how to add new created Active Directory users (that paid hosting plan customers can request via our helpdesk) to your SharePoint 2013 and Access Services 2013 database.

Posted in Access 2013, SharePoint 2013, Video Tutorial | Tagged , , , | Leave a comment

Web Reporting with Access 2013 Web Apps on Office 365

We are happy to report that our Remote Desktop hosting can be configured to connect to Office 365 to use Access to report on your Access 2013 web apps.  Our Remote Desktop hosting allows you to use the power of Office 365 as your backend and then you can use our HTML5 PowerRDP technology to get around Office 365’s inability to render Access 2013 reports in the web browser.  This is a great way to get more out of your Office 365 subscription with MS Access 2013.  If you already have a $29/month Access 2013 Pro or Office Pro plan, you should be able to follow the quick tutorial below to start building web reports for Access 2013 web apps.

Step 1: Open your Access Web App in MS Access 2013

reporting-office365-msaccess13-1

Login to Office 365 and Navigate to your Access Web App.  Click the customize in Access button to download the Access 2013 .accdw file and open it in Access 2013.

Step 2: Report on your Access Data

report-on-my-data-office365-msaccess13

Navigate to the Info tab of your Access 2013 web app file (accdw) and select the “Report on my Data” button to create an Access frontend that can report on your Office 365 / SharePoint 2013 backend.

Step 3: Create Reports in your Access Frontend

reporting-office365-msaccess13-2

Now that you are using linked tables to connect to Office 365 and your SharePoint 2013 Access Web App, you can take advantage of all the features of the full version of the Access 2013 desktop client.  Create and design your reports, forms and queries.  Remember to close and save all reports and save your Access frontend file on the Remote Desktop.

Step 4: Reporting now works on Office 365

reporting-office365-msaccess13-3

Now your reports are connected to Office 365 and accessible from any machine, tablet, device and web browser via our Remote Desktop hosting!

Posted in Access 2013, Office 365, Tips & Tricks | Tagged , , | Leave a comment

What is the difference between Access and the Microsoft Access Runtime?

Unless you’re an Access developer, you’ve probably never used the Access Runtime before. Since our basic RDP hosting plan comes with only the runtime, we get a lot of questions about what the runtime is and how it is different from the version of Access on their computer and which remote desktop hosting plan would work best for their Access database.  Hopefully, this post will help steer you in the right direction.

What is the Access Runtime?

Microsoft describes the runtime as such, “The Microsoft Access Runtime enables you to distribute Access applications to users who do not have the full version of Access 2013 installed on their computers.”  It’s a free download from Microsoft as opposed to part of the expensive Office Professional suit that includes the full and powerful version of Access that Access developers have installed on their desktops.  It’s the equivalent of Adobe Reader – it lets you open PDFs and is free, but lacks many of the features found in Adobe Acrobat.  If you want to do anything of meaning in Access or if you’re an Access developer, you want the paid, full version of the program.  The runtime is intended to be used with already designed databases so data-entry and other users can simply open your database file and interact with your forms and access application.

I still don’t get it

Let’s take a closer look at the famous Northwind Traders database in the Access 2013 runtime and the full version of Access.

Northwind Traders in Access 2013 runtime

Northwind Traders in Access 2013 runtime

As you can see this complex database easily opens in the Access Runtime and gives you access to everything that was designed in the Access App: create new customers, view invoices, etc.  But you’ll notice that there is no Access ribbon and you cannot use the navigation and or see the database structure and design.  There are really no tools beyond what is built within the database.  I’m sure you can see the advantage of this type of security for Access developers.  The Access Runtime makes it impossible for a user to alter their application and they can even have limited access to the database and records themselves.

Northwind Traders in Access 2013 full version

Northwind Traders in Access 2013 full version

Here is the same database in the full version of Access 2013.  I have access to all of the tools in the ribbon.  I can create new forms, queries, reports or view the tables and records directly using the left sidebar navigation menu.  None of these features are available in the Access runtime.

The Access runtime only really has one menu that is included in every database – the file menu.

access runtime file menu

All this menu really lets you do is print the forms and reports that you are able to access in the secure stripped down version of the already developed Access database application. Conversely, the full version of Access lets you create new databases, edit and save databases, print and much more from it’s file menu:

the real access 2013 file menu

Hopefully this has helped you figure out what the Runtime is all about.  If the limited nature of the runtime works for you, then our $19 RDP hosting plan should work for you and your already developed Access database.  If you are more comfortable with the full paid version of Access installed on your computer, then you will want to go with our $29/month remote desktop hosting plan.

 

Posted in Access 2013, Access Runtime, FAQ, Tips & Tricks | Leave a comment

Running MS Access Applications on an Android Kindle Fire

Running your Access application on the Kindle Fire can be accomplished in just a few simple steps.

img_52b899958a37e

Here’s what to do:

1. Download the Microsoft Remote Desktop APK and move it over to the Kindle Fire via USB or emailing it to yourself. Note that this is a zip file and you will need to unzip it before moving it over.

2. Change your default Android Kindle settings to allow This is known as “sideloading” your application into Android. You may need to setup the Kindle to accept unknown applicaitons first by doing this:

Fire Settings

Click your settings tab

Fire Applications

Navigate to Applications

Fire Settings 2

and allow applications to be installed from unknown sources (set to On)

3. Install the Microsoft Remote Desktop application to your Kindle.  You can do this by navigating to your Downloads folder (if you emailed it to yourself) or the folder that you placed it in via your USB connection.  We’ve found the free ES File Explorer app to be incredible helpful way to browse your Kindle’s Harddrive.

img_52b888ad593f2

3. Pin the newly installed Microsoft Remote Desktop application to your home screen

new RDP

4. Configure the Remote Desktop Connection. If you are using our Remote Desktop Hosting Service  this information will be provided via email.

rdp config

5. Connect the Remote Desktop and run your Access application. Our Remote Desktop Hosting Service is available for Access 2007/2010/2013 and the Access 2010/2013 Runtime

This new version of the Remote Desktop client supports all of the Kindle gestures and features easy to navigate keyboard and mouse touch screen equivalents. Your users will find that the Access .mdb and .accdb applications they know and love work just fine on the Android Kindle Fire Tablet.

 

 

Posted in Access 2003, Access 2007, Access 2010, Access 2013, Access on the Kindle, Remote Desktop, Remote Desktop Hosting, Tips & Tricks, Video Tutorial | Tagged , , , , , , | Leave a comment

New Remote Desktop App for Windows 8.1

Microsoft has released a Remote Desktop application for Windows 8.1 users here. This is a significant improvement over the traditional RDP or RDC client and offers some unique features. In addition to improved performance and reliability this updated app includes:

On-Screen Keyboard

For devices that do not have a physical keyboard attached, the Remote Desktop app now provides an easy way to bring up the touch keyboard from the command bar. Simply swipe from the top or bottom edge of the screen and tap on the Keyboard icon.

Dynamic Resolution Update

Another improvement available in Windows 8.1 allows the Remote Desktop app to dynamically update the resolution of the remote system when the local resolution or size of the app changes to provide the best experience.

There are multiple ways you can see this in action. First, if you have a tablet device that supports rotation (like the Microsoft Surface 2), you can rotate the device with a live connection to a remote PC and see the resolution in the remote session automatically update to reflect the change in orientation without the need for a full reconnection. Depending on your connection speed, the rotation can be as fast as the local resolution.

This new version is fully compatible with our Remote Desktop Hosting solutions for MS Access.

 

Posted in Access 2007, Access 2010, Access 2013, Remote Desktop, Remote Desktop Hosting | Leave a comment

Access 2013 Tip Of The Week

This short video shows you how to expose all of the web database templates available for Access 2013. Works on Office 365 and hosted implementations of Access Services 2013.



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

Using a SharePoint 2013 Foundation List as an Access Backend

We are happy to announce the availability of low-cost SharePoint foundation hosting plans. These plans start at only $99 a year and while they do not have the publishing features of Access Web Services, these SharePoint 2013 plans are still great for Access Developers. You can use SharePoint Lists as you backend and easily have anonymous website users add information and input data using SharePoint’s list functionaliy without having to pay per user enterpise license fees. Watch the video below to see the type of Access development and features that we’re talking about:



Posted in Access 2007, Access 2010, Access 2013, SharePoint 2013, Video Tutorial | Tagged , , , , | Leave a comment

Running Microsoft Access 2003/2007/2010/2013 on a single machine .. and that machine is an iPad

No parlor tricks here – just the Microsoft Remote Desktop App connecting to hosted remote desktops running the last 4 (count em FOUR) major releases of MS Access. This allows most applications to run unmodified in the cloud using the version of Access they were originally developed in. Take Access anywhere using any device without the hassle and expense of application rewrites.



Posted in Access 2003, Access 2007, Access 2010, Access 2013, Access and the iPad, Remote Desktop, Remote Desktop Hosting | 2 Comments

Adding a Splash Screen to Your Access 2013 Web Apps



Posted in Access 2013, Office 365 | Leave a comment

Best of Both Worlds: Upsizing Your Access Database to SQL 2012

Access Migration

An important feature of our remote desktop hosting service is the ability to upsize an Access database to SQL Server 2012 with the SQL Server Migration Assistant (free download link below)

Here is a video of the Migration Assistant in action:


Download the Microsoft SQL Server Migration Assistant for Access Databases

http://www.microsoft.com/en-us/download/details.aspx?id=28763

By combining a remote desktop Access frontend with a SQL Server on the same high speed switching fabric you get the best of both worlds: A secure, scalable database application combined with the ease of Microsoft Access on any device.

Here is a video overview of the Microsoft SQL Server Migration Assistant in action.

Your Remote instance of Access can now be paired with SQL Server over our high speed network switching fabric, eliminating the traditional latency of a web based SQL backed.

In many cases the migration assistant can be used effectively without outside assistance – but if you require a helping hand we can recommend qualified Access and SQL Server experts that can assist for a reasonable one time fee.

 

Posted in Access 2010, Access 2013, SQL Hosting, SQL Server 2012 | Leave a comment

Introducing Microsoft Access 2013



Posted in Access 2013, Remote Desktop | Leave a comment

Shop for Federal HealthCare with Access 2013

To demonstrate the anonymous access capabilities of an Access 2013 web application we downloaded the latest Federal Healthcare pricing information and created an app on Office 365 at

http://catfi.sh/obamacare

You can type in your county name and browse all of the plans and providers in your area.

No registration or signing in required.

All of this was created without writing a single line of code. Pretty cool stuff.

Posted in Access 2013 | Leave a comment

Compare Access 2013 web apps vs. Access 2007/2010/2013 Remote Desktop Databases

 USE AN ACCESS 2013 APP IF …

  • Your organization is using  Office 365 with SharePoint Online
  • You have the time and budget  to convert your databases tables, queries, forms and reports  into a SQL/Web compatible format
  • Everyone who needs to create or modify an Access app has a copy of Access 2013.
  • The problem you’re trying to solve doesn’t require advanced database features like VBA or automation of Outlook, Word and Excel.
  • You want the latest version of Access and are willing to be upgraded automatically every few years.
  • Your reporting needs are very basic

USE AN ACCESS REMOTE DESKTOP DATABASE IF …

  • Your organization is not using SharePoint or your Office 365 plan does not include SharePoint Online.
  • You want complete control over the look and feel of the database user experience.
  • Your users want to bring their own device (iPad, Nexus, Kindle) to the Access application.
  • You enjoy using the Access Form and Report Wizards.
  • You need advanced features, such as Visual Basic for Applications (VBA) or need to extend your application with email (Outlook) and  charts (Excel)
  • You don’t mind waiting for the next release of Access to use the latest features.
  • You have complex reporting needs, beyond the simple summary reports provided in Access apps; for example, you need to integrate other databases into a report, or format the report.
Posted in Access 2007, Access 2010, Access 2013, Access and the iPad, Access Runtime, Remote Desktop Hosting | Leave a comment

Free Remote Desktop Client for iOS, OS X and Android now available from Microsoft

Breaking News: You no longer need to purchase third party software to connect your Mac, iPhone, iPad, and Android devices to our Remote Desktop Hosting Service . You can now run the Access Runtime (2010 or 2013), Access 2007, Access 2010 (32 and 64 bit) and Access 2013 (32 and 64 bit) on all these devices with a FREE app. Wow.

Download links:

https://play.google.com/store/apps/details?id=com.microsoft.rdc.android – Remote Desktop for Android download

https://itunes.apple.com/us/app/microsoft-remote-desktop/id714464092 – Remote Desktop for iOS download

https://itunes.apple.com/us/app/microsoft-remote-desktop/id715768417 – Remote Desktop for OS X download

Remote Desktop Hosting Information and Free Trial Offer: http://accesshosting.com/remote-desktop-hosting

If your device is not supported for any reason (Amazon Kindle Fire HDX  and the Silk Browser come to mind) you can still run these apps inside any HTML5 browser using our Power RDP solution http://accesshosting.com/power-rdp-run-native-access-applications-browser

It looks like the era of Access Anywhere has arrived. And it is the REAL Access you know and love – not the Access Web stuff that requires rewriting your existing applications.

 

Posted in Access 2007, Access 2010, Access 2013, Access and the iPad, Access Runtime, Remote Desktop, Remote Desktop Hosting | Leave a comment

Access on the iPad – now featuring Power RDP and iOS7

We recently updated our popular YouTube video that shows Access running inside the Safari and Chrome browsers on the iPad with iOS7. This new and improved solution requires no extra software and allows Access 2007, 2010 and 2013 applications to run without modification.


Posted in Access 2007, Access 2010, Access 2013, News, Video Tutorial | Leave a comment

4 Unique Features of an On Premise or 3rd Party Hosted Access Services 2013 implementation

Microsoft Office 365 provides anywhere access to your familiar Office applications, email, calendar, video conferencing, and most up-to-date documents, across your devices – from PCs to smartphones to tablets. Choose to run it the way you want with enterprise-grade security, IT controls and flexible deployment options that let you run it on-premises, as a hosted service or as a hybrid of both.

However, even an enterprise-class productivity and hosting solution like Office 365 will not fully meet the Access web database needs of all customers. An On Premise or 3rd Party Hosted Access Services 2013 implementation helps provide focused, reliable solutions for the following common customer needs:

1. Full control of SQL Server security: Access 2013 allows for the automatic creation of 2 SQL Server user accounts, one with read-only privileges and another with read-write. While that is useful, some customers would like to extend this model to multiple user accounts. By creating multiple SQL logins via SQL Server Management Studio (SSMS) you can create a much more complex security model for applications that want to leverage the Access 2013 web database information stored in SQL Server. Password complexity and aging requirements can also be enforced on these accounts.

2. Full control of the network firewall: Many Access 2013 applications require extended security to comply with corporate or regulatory requirements. The Health Insurance Portability and Accountability Act (HIPPA) security requirements are a good example of this necessity. In a self-hosted or 3rd party hosted solution you have enough firewall configuration flexibility to lock down your entire database by imposing restrictions on the network perimeter based on TCP/IP address ranges, machine names, and network protocols. A combination of these restrictions can be imposed to address any security mandate.

3. Render http links in the web browser control of an Access 2013 web database: The browser control is a powerful feature in Access 2013 web forms that allows you to call external resources into your application. Office 365 requires https for all external links which limits the use of browser based resources that do not support https. This restriction can be lifted in a self-hosted or 3rd party hosted configuration.

4. Customized backup: You can create a backup rotation scheme in SQL 2012 for the Access Web Apps that mirrors the site collection backup routine in SharePoint. This allows for a synchronized full fidelity backup of the SharePoint site and the Web Apps with multiple restore points. We recently assisted a customer who required a complete snapshot of their SharePoint and Access Services environment to be available for rollback to 24/47/72/96 hour recovery points. In addition, the second and fourth snapshots needed to be available in a secondary data center in the event of a problem with the primary facility. All of this is easily accomplished in a hosted configuration where both the SharePoint and SQL Server environments are completely controlled by the hosting organization.

Posted in Access 2013 | Leave a comment

Moving Your Microsoft Access Database to the Cloud

A Simpler Approach

AccessHosting.Com offers a unique, low cost, and scalable approach to getting your Access database into the cloud. Our entry level price point is just $19 month for a remote desktop session that allows a single user to run their Access 2007, 2010 or 2013 database without modification, and includes the rich feature set that Access developers are comfortable using and maintaining. Don’t be confused by the marketing hype surrounding Access Services and SharePoint in Office 365 – those solutions require significant conversion effort and a substantially reduced feature set to run Access forms, queries and reports in the browser. Our simple approach lets you take your existing database from the desktop intact with forms, rich reports, VBA code, and legacy macros and run it from any device that supports a remote desktop connection. That includes iPads, Kindle Fire, Surface Tablets and many other popular devices.

An Inexpensive Solution

With the Access Runtime environment you do not need a copy of Access for you users – only the developers of the applications. Without this requirement the cost of running your application remotely can be as little as $19/month per user. Additional users can be installed at any time to share a common backend database that is secured on the same remote desktop, offering a high performance solution to multi-user connectivity.

A Scalable Solution

Sometimes Access databases grow up to be very big – and performance suffers. We offer an easy way to take your traditional Access data file and convert it to a hosted SQL Server solution on our same network switching fabric, giving you a high speed connection to a scalable backend that will not impact performance as the size of your database grows.

How Do I ?

We understand that you sometimes need step by step guidance to perform a specific task. To that end we have produced many instructional videos to help you get started with our solution. Everything from moving your database form the desktop to the remote desktop, setting up local printing, and securing multiple users on your database is covered in detail in these tutorials.

Want To Learn More?

We are convinced that this is a great way for people to run Microsoft Access on the Web – but don’t take our word for it. You can test out solution obligation free for 30 days. There are no long term contracts or the “lock-in” typically found with QuickBase, Caspio, and other web database solutions. If the product does not meet your needs you will not be charged – simple as that.

Posted in Access 2003, Access 2007, Access 2010, Access 2013, Remote Desktop, SQL Server 2012 | Leave a comment

Download Access 2007, Access 2010 and Access 2013 Runtime

The Microsoft Access 2013 runtime has been released.

The wait is over for Access 2013 Runtime. Here are the download links for the last 3 versions of the MS Access Runtime environment. Remember that you can use these runtime packages to deploy Access Applications free of charge. They make a great low cost solution for putting legacy Access applications on the internet, the iPad, and most Android devices WITHOUT the hassle and expense  of conversion using our Remote Desktop Hosting and SQL 2012 Hosting Plans.

Access 2013 Runtime Download

Access 2010 Runtime Download

Access 2007 Runtime Download

Remote Desktop Hosting Plan Free Trial

SQL 2012 Hosting Plan Free Trial

 

Posted in Access 2013, News, Remote Desktop Hosting, SQL Hosting | Leave a comment

Create a SharePoint 2013 List using Access 2013

Posted in Access 2013, Video Tutorial | Leave a comment

How to add users to your SharePoint 2013 Site Collection and Database

This first video demonstrates how to Add Users to Your SharePoint 2013 Site Collection with SharePoint Designer 2013

This tutorial shows you how to Add Users to Your SharePoint 2013 Site Collection via the browser

Posted in Access 2013, Video Tutorial | Leave a comment