Category Archives: Remote Desktop Hosting

Microsoft Azure RemoteApp is no more, but don’t worry we can help!

New purchases of Azure RemoteApp ended October 1st, 2016, so where do you go if you need RemoteApp hosting? For the time being Microsoft will continue to support existing Azure RemoteApp customers on the service through August 31st, 2017, when the service will be shutdown – but then what?

For those unaware, Microsoft Azure RemoteApp brought the functionality of the on-premises Microsoft RemoteApp program, backed by Remote Desktop Services, to Azure. Azure RemoteApp helps you provide secure, remote access to applications from many different user devices. Azure RemoteApp hosted non-persistent Terminal Server sessions in the cloud.  This technology is very similar to our long offered Remote Desktop Hosting Services.  It is the same basic technology stack but RemoteApp direclty launches a specific application rather than a full windows virtual environment.  We have already been contacted by a lot of Azure RemoteApp customers and are happy to report that we are happy to offer a hosting alternative to Azure RemoteApp (or the expense of Citrix).  We are happy to announce that we are more than capable of creating an RDP RemoteApp server for your business needs.  We believe that we can offer low-cost hosting plans for remoteApps of any Microsoft Office programs (including MS Access) and if you’ve developed your own Windows Software or specialized app, we can setup a dedicated Windows RemoteApp Server to host and distribute your software in the cloud.

Please contact our technical team if you’re interested in setting up a free RemoteApp Trial.

Posted in News, Remote Desktop, Remote Desktop Hosting | Tagged , | Leave a comment

How to Create a Login Form for MS Access

Before creating a Login Form, you need to set up a user table that can verify the login ID and password on the Login Form. The step of creating Login Form can be followed below:

Create a table tblSecurity with a SecurityID and SecurityLevel field and add admin for SecurityID =1 and user for SecurityID =2

securitystep1

Create a table tblUser with a UserName, UserLogin, UserSecurity and UserPassword fields.  Remember to add an input mask on the password field so that passwords are not blatantly visible in the table.

securitystep2

I choose to display the type of user rather than just the raw number of the User’s security level by using the Lookup options in the design view. This way the UserType field is a number corresponding to the User’s security level because it refers to the SecurityID in the tblSecurity but displays the user’s UserType in text (admin, user etc.). You can create the UserType field from the Lookup Wizard on the dropdown of Data Type column.

usertype

Create a Login Form from the Dialog form design. Then customize the form to your liking.

how-to-create-a-user-login-form-in-ms-access

Create two text boxes in the Login Form as txtUserName with label Login Name and txtPassword with label Password

create-a-login-form-ms-access-2016

Under the “On Click Event” of the Cancel button, add the Embedded Macro with a QuitAccess command to exit the program or Access application

how-to-creat-a-login-form-macro

Create a Navigation and Admin Form area to reroute your users to the appropriate area of your database application.

Under On Click Event of the OK button, add the VBA code below under the Event Procedure

Option Compare Database

Private Sub Command1_Click()
Dim User As String
Dim UserLevel As Integer
Dim TempPass As String
Dim ID As Integer
Dim UserName As String
Dim TempID As String


If IsNull(Me.txtUserName) Then
 MsgBox "Please enter UserName", vbInformation, "Username required"
 Me.txtUserName.SetFocus
ElseIf IsNull(Me.txtPassword) Then
 MsgBox "Please enter Password", vbInformation, "Password required"
 Me.txtPassword.SetFocus
Else
 If (IsNull(DLookup("UserLogin", "tblUser", "UserLogin = '" & Me.txtUserName.Value & "' And UserPassword = '" & Me.txtPassword.Value & "'"))) Then
 MsgBox "Invalid Username or Password!"
 Else
 TempID = Me.txtUserName.Value
 UserName = DLookup("[UserName]", "tblUser", "[UserLogin] = '" & Me.txtUserName.Value & "'")
 UserLevel = DLookup("[UserType]", "tblUser", "[UserLogin] = '" & Me.txtUserName.Value & "'")
 TempPass = DLookup("[UserPassword]", "tblUser", "[UserLogin] = '" & Me.txtUserName.Value & "'")
 UserLogin = DLookup("[UserLogin]", "tblUser", "[UserLogin] = '" & Me.txtUserName.Value & "'")
 DoCmd.Close
 If (TempPass = "password") Then
 MsgBox "Please change Password", vbInformation, "New password required"
 DoCmd.OpenForm "frmUserinfo", , , "[UserLogin] = " & UserLogin
 Else
 'open different form according to user level
 If UserLevel = 1 Then ' for admin
 DoCmd.OpenForm "Admin Form"
 Else
 DoCmd.OpenForm "Navigation Form"
 End If

 End If
 End If
End If
End Sub

Private Sub Form_Load()
Me.txtUserName.SetFocus
End Sub

Set the Login Form to display immediately when the Access Database is opened. Go to File->Options and select the Current Database option from the list. Then set the Login Form as the display form.

set-a-display-form-for-when-access-first-opens

It should be noted that while this login procedure is helpful to have permissions and different roles withing your Access database and may be needed for our Remote Desktop Hosting – it is not necessary for any hosted Access Web App or Sharepoint Application since you can use the Sharepoint user roles and login procedures rather than handling it within the Access Database itself.

Posted in Access 2016, Remote Desktop Hosting, Tutorial | Tagged , , | 51 Comments

How to Connect Microsoft Access to QuickBooks

QuickBooks is an accounting application that many individuals and small business owners use to manage their finances. It allows you to maintain a variety of database files such as customer contact information, budgets and inventory records.

Microsoft Access, on the other hand, is a broader database application, which can store everything from mailing lists to financial data and everything in between. While many users enjoy the convenient financial tracking that QuickBooks provides, they also like the flexibility and advanced query options that Microsoft Access offers.

The good news is that you can merge these two different applications. This allows you to record your financial and business records efficiently, while still being able to create a variety of queries for analytical purposes.

In order to connect Microsoft Access to QuickBooks, you will need to use an ODBC driver like QODBC. While this driver does not import files from or into these applications, it does allow Microsoft Access users to view their QuickBook files externally.

You will still be able to be able to create all the tables, queries, reports, modules and macros using data stored in your QuickBook files, just as you would your files stored in Microsoft Access. Data within these files is updated instantly whether you are working in QuickBook or Microsoft Access.

The process for connecting Microsoft Access and QuickBooks is fairly easy and can be completed within just a few minutes. Below is a look at the seven steps you need to take to connect these two applications.

2016-09-20_9-14-19

  1. Start by opening up your Microsoft Access application. You can do this by clicking the Start button on your desktop, selecting Microsoft Office and choosing Microsoft Access. Select the Blank Access Database Click the OK button.
  2. A default name will appear in the File Name Feel free to edit the name of the file to better meet your specific needs. This name cannot match any other file name within your Microsoft Access database. When you are done, click the Create button.
  3. Click the New tab at the top of the box.
  4. The Microsoft Access database wizard box will appear. Select Link Table. Click the OK
  5. Locate the Files of Type box at the bottom of the screen. Use the drop down box to change the Files of Type from Microsoft Access to ODBC Databases.
  6. The Select Data Source box will appear. Select QuickBook Data or another DSN Data Source you set up with your QODBC driver. Click on the OK
  7. The Link Table will appear, which lists all the tables from QuickBook that you can now access with Microsoft Access. Select all the QuickBook tables you want to connect to Microsoft Office. Click the OK

You will now be able to view all your QuickBook tables in Microsoft Access. It is important to note that this process technically does not import your QuickBook files into Microsoft Access. Instead, Microsoft Access will open these external files through the QODBC driver.

This allows changes to be updated instantly whether you are working in QuickBooks or in Microsoft Access. This creates fewer errors and ensures your records stay up to date at all times.

If you create a table in QuickBooks, you will need to repeat steps one through seven to make sure these new files are connected to your Microsoft Access.

Posted in Access 2007, Access 2010, Access 2013, Access 2016, quickbooks hosting, Remote Desktop, Remote Desktop Hosting | 1 Comment

8 Benefits of Using Collaborative Software in the Cloud

Cloud technology was a global phenomenon just a few years ago, but it is now integral part of business operations. The cloud has been particularly helpful to companies that use collaborative software like Microsoft Office, specifically Excel and Access, as it allows for safe, quick and encrypted access to potentially sensitive data — from anywhere in the world.

If you are contemplating moving your collaborative software to the cloud, there are eight very clear benefits of doing so.

1. Reduced Hardware Costs

The cost of purchasing and installing sophisticated IT systems can be considerable, particularly for startups and small businesses. But using the remote servers of a cloud provider like Access Hosting means companies and relatively small organizations can bypass these costs and save money. There is no systems maintenance or management cost, but just a fixed monthly subscription that makes financial planning simple.

2. Reliable Security Features

The use of collaborative software can pose significant security problems. Several users all accessing and sharing the same data via different devices is a situation with inherent risk. But cloud storage providers offer protection from all the latest viruses and malware. And depending on the provider, there may be the option of two-factor authentication at login. Most cloud providers offer automatic updates, which means businesses don’t need to pay IT specialists to update several physical servers and devices with the latest protection.

3. Remote Working

This brave new world of cloud computing is making the traditional office environment increasingly obsolete. Users with access to collaborative software in the cloud can view, share and update files from anywhere in the world with an Internet connection. That means you can collaborate in MS Access, Excel or even Quickbooks without having to physically be in the office. This can reduce costs, improve staff morale and boost productivity levels.

4. Reduced Operational Costs

Most businesses have fluctuating bandwidth costs, so there’s often a need to scale up and scale down capacity at short notice. Cloud storage allows businesses to pay for only the capacity they need, rather than wasting cash on excess storage and bandwidth.

5. Seamless Collaboration

The success of collaborative software — such as the many packages developed by Microsoft Office 365- relies on the ability to share, view and edit files in real time. Any updates made to files in cloud storage are immediately available to all users, so they’re able to make their own contributions in the knowledge that they have the latest information at hand. Best of all, our terminal services collaboration plans allow for developers to leave their MS Access Database as-is and move it into the cloud seamlessly.

6. Cost-Effective Disaster Recovery

Every business needs to prepare for the worst when it comes to data storage. A man-made or natural disaster has the potential to wipe out a business’s data in seconds, so having a plan to continually back up data — and restore lost data — is essential. However, this can be a complex and costly process, and it can put a huge financial and administrative strain on small organizations. Collaborative software in the cloud usually includes disaster recovery measures, saving businesses time and money.  Access Hosting takes daily backups of our architecture and you can add individual file backups for as little as $20/month.

7. Improved Competitiveness

Small businesses often struggle to compete financially with their larger competitors. Collaborative software in the cloud can level the playing field in this respect. Cloud computing is cheaper than installing and maintaining physical IT infrastructure, which makes it possible for smaller organizations to be competitive within their industries.

8. Restricted Access Based on Security Clearance

In an organization with hundreds of employees, it is inevitable that certain people will need to access sensitive files that aren’t for general consumption. Providers of cloud-based collaborative software offer varying levels of user access, so sensitive data remains private.

Cloud technology gives businesses flexibility, reliability and simplicity — and cuts the cost of doing business. This is why more and more organizations are transferring their collaborative software to the cloud.

Posted in Amazon Web Services, blog, quickbooks hosting, Remote Desktop Hosting, SharePoint 2013, SharePoint 2016, SQL Hosting, SQL Server 2012, Windows Server 2008, Windows Server 2012 | Leave a comment

Remote Desktop Hosting Guidelines and Security

We thought it would be helpful to layout some of the common guidelines and best practices to get the most out of your Remote Desktop Hosting Plan.  Here are some brief guidelines about our shared RDP hosting plans and how best to secure your data.  If you are on a dedicated server, you do not have to worry about any of these guidelines.

  1. FILE SECURITY: Remember that you are on a shared server with other users.  Do not create folders or save files to the C:\ Drive yourself since other users may be able to access these files.  Save everything to your Desktop or My Documents folder – these areas are completely secure and invisible to other users.  We do our best to monitor this but are not responsible for any data that you have saved to the C:\ Drive without consulting us or having us setup a secure folder.
  2. FILE BACKUP: Backup of individual files, folders and databases on your remote desktop are NOT INCLUDED.Before making substantial changes to your Access Database, we recommend copy/pasting it down to your local computer so that you can restore your database if anything goes wrong. We also offer automated daily file backup and retention solutions for $20 per month. Unless you have purchased a backup plan, We are NOT responsible for your individual files and folders.
  3. PASSWORD SECURITY: You are responsible for your password and should not share it with anyone.  If you share your password with our technical support team, you should change it after they have resolved the issue.  If at any time you feel that your account or password has been compromised, you should login to your Remote Desktop and change it by pressing <CONTROL><ALT><END> to bring up a menu that allows for changing the password.
  4. SOFTWARE INSTALLATION: Our low cost RDP hosting is built as an out of the box solution and does not permit the installation of any additional software, controls, etc for security reasons.  The environment prevents the installation of software for your protection.  If you need to run executables and install additional software, please contact us about a dedicated server environment.
  5. TERMS OF SERVICE: Anyone found violating our terms of service will have their remote desktop deactivated immediately and without notice. This is especially true for anyone found installing Spyware, Malware, Bots, Spam Software, Phishing Software or any other unlicensed and unauthorized programs.

If you have any questions, please do not hesitate to contact our technical support team: http://support.accesshosting.com

Posted in Remote Desktop, Remote Desktop Hosting | Leave a comment

Using Google Chromebooks with our RDP hosting Plans

Chrome RDP

We recently had a question about using Chromebooks to access our Remote Desktop Hosting and if they work.  The answer is that they absolutely do if you grab an RDP App and install it on your Google Chromebook.  It’s actually a great and cheap way to give your employees a laptop where they can still access a file server and the Microsoft Office Suite since all they need is an internet connection.  Here are the very few quick steps to use a Chromebook with your RDP hosting plan:

1. Download the Chrome RDP App from the Chrome webstore: https://chrome.google.com/webstore/detail/chrome-rdp/cbkkbcmdlboombapidmoeolnmdacpkch?hl=en-US

2. Write down or copy the IP address and port from the RDP link that you received when you signed up for an account.  Type/paste that information in the first startup screen:

Chrome RDP

3. Click connect and then enter your login credentials.  Your username prefix should be used as the domain.

logininfo

4. Click OK to connect to the Windows Server and your RDP hosting environment.

Windows on Chromebook

 

 

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

New Robust Backup Options for Remote Desktop Hosting

941_amazon

Access Hosting is happy to announce a more robust and granular backup option for our Remote Desktop Hosting customers.  We have always done daily backups on the entire server which helps us recover from any failure but does not help customers looking to rollback a specific Access or Excel file to a previous version.  We have spent the last month integrating our server architecture with Amazon Web Services and are happy to report that we are now able to backup individual ms Access, Office, and other files on a daily or even hourly basis based on your desired needs.

Any current Remote Desktop customers can upgrade their plan with these new backup options.  You ONLY need 1 backup plan – it will cover all of your users and files.  You DO NOT need a backup plan for each RDP user account.  These backup plans can also be added and applied to a dedicated Remote Desktop Server.

Daily Backup – $10 per month

With this backup option, we will archive, store and backup all of your files offsite on our Amazon AWS servers on a 24 hour cycle.  If at any time you make a mistake or a MS Access database or other file gets corrupted, we can roll back a specific file to the previous day’s version.

Order Daily Backup Now!

Hourly Backup – $20 per month

With this backup option, we will archive, store and backup all of your files offsite on our Amazon AWS servers on an hourly basis.  If at any time you make a mistake, we can roll back and restore a specific file to a previous version that was saved every hour.

Order Hourly Backup Today!

If you have any questions or specific backup needs, please contact our technical support team.

Posted in Access 2007, Access 2010, Access 2013, Amazon Web Services, Excel 2013, Remote Desktop, Remote Desktop Hosting | Tagged , , , , , | Leave a comment

The Top 10 Reasons to Split an Access database

Splitting your Access database offers numerous advantages, including increased flexibility, security, efficiency, and scalability.

Access is an amazing and powerful desktop application that lets you store data and interface with that data in the same file. You can even design your own applications with Access.  Unfortunately, the only way to utilize the full power of MS Access  is to develop traditional local desktop based applications.  Luckily, you can take your powerful MS Access applications with split frontend and backend to the cloud with Access Hosting’s Remote Desktop Hosting.

Most developers agree that a split database is easier to protect and maintain but unfortunately this powerful approach is completely incompatible with SharePoint.  When you split an Access database file, you end up with two files instead of just one (often the backend is an .mdb file):

  • The backend stores all of the data in relational table (you can always move the backend to SQL for even more power and accessibility)
  • The front end stores all of your interface objects: forms, reports, queries etc.
  • By linking the two files, users can view and manipulate the data in the backend via the forms and reports in the front end. This arrangement solves a number of problems inherent to the Access file structure.

Now onto the top 10 reasons to split a Microsoft Access Database:

1: Multiple users share the data
Perhaps the biggest incentive for splitting a database is to supply data to multiple users over a local network or on the cloud via Access Hosting. By storing the backend on a local file server, SQL or other cloud based solution and distributing the front end to workstations and users, many users can access and manipulate the data at the same time without running into record locking and other problems.

2: Everyone’s using the same data at the same time
By splitting a database, you know that all users are accessing the most current data because everyone’s accessing the SAME data. Not only are they all accessing the same data, they can all update it at the same time. That means a change made by one user is almost immediately available to all other users.

Having a backend moves all the data into a single database file (.mdb) or backend ODBC connection (SQL, mySQL etc). That means there’s only one copy of that data to manage and protect. Changes are immediate and available to all authorized users. Any administrative and development duties are implemented in the backend file, once.

3: Your data is better protected
Whole books have been written on database security, but it’s enough for you to know that you must protect your data. One of the easiest ways is to split your database. Placing your tables in a backend file protects your database design because users can’t directly access the tables via the interface objects in the front end.  Therefore, they can’t alter or delete tables, even accidentally. Most of the users working in the front end won’t realize they’re actually working with two separate files, so splitting the database will have NO Negative impact on your users.

However, this arrangement is not a comprehensive security lock on design. Users who know what they’re doing can still open the backend, if they have access to it. Just bear in mind that splitting the database will minimize accidents — but it won’t stop someone who’s determined to get at your tables.

If security is a of utmost importance, Access Hosting’s Remote Desktop hosting adds an additional layer of security – requiring users to login to the MS Access frontend.  Users don’t even need to have Access installed on their computer!  We even offer HIPAA compliant dedicated server solutions for healthcare and medical data.  Moving your data to a SQL backend also adds additional security and features to an Access application.

4: You can easily scale your application for the future
If there’s any chance that your Access database will grow out of its skin, consider splitting the database. It’s easier to upsize a split database to SQL Server (or some other larger relational database system) because you can easily link the existing front end to SQL Server tables. That way, the organization has the advantage of storing data in a larger database with most of the perks that come with doing so, while still using the interface and all of the reports and queries that you originally designed in the Access front end.

5:  The user interface is easy to modify
Most databases grow and change with the business; they require new features or modified business rules. Changes to existing tables are rare, if you properly normalized them early on. Most changes will be in the front end in the form of new or modified forms and reports.

As long as your database is split, testing and implementing changes to the front end can occur with little or no disruption to users. You simply link the development front end to the production backend and test away. This won’t always be the case, of course, but testing new interface objects is easier in a split database configuration.

6: Deploying a new front end is a snap
If the user interface and data are stored in the same database, you must REPLACE the entire database EVERY time changes are made in a local environment.  With our RDP solution, you can keep your database and app contained all in one file and more easily replace them on our server in 1 location, but it’s still not ideal.  That’s a lot of unnecessary work and is especially problematic if no one in-house has the expertise to do it for you or if you have to visit each user’s workstation.

In a split database configuration, you simply replace the front-end ms access file and relink the tables. It takes a few minutes and requires little interruption of users.  With our RDP solution, you can even login and do this for every user to completely eliminate any application support issues.

7: It makes life easier for offsite developers
A split database is easier for offsite developers to maintain and upgrade. The developer works offsite to implement changes and enhancements to the front end and then ships the new version to someone in-house (or uploads it directly) who has the technical expertise to deploy it. This latter process is a simple copy and relinking task that doesn’t require high-end expertise. You can train someone to do it or even talk someone through it over the phone. Many developers write a routine that automates the process. All the in-house technician has to do is double-click the installation file. This opens up a lot of long distance opportunities that a developer just couldn’t manage as easily with a single database file.  Access Developers out there should interested in making their lives easier and moving their clients to a cloud based hosting solution should contact us about our Partner and Referral program.

8: Geography’s not a problem
A split database allows users in different locations to access the same data. For example, the backend could be stored on our servers in our SAS70 data center in Philadelphia, but users from all over the country can access the data via their local systems connected to a SQL backend.

9: Corruption is limited
Access databases are prone to corruption. One of the easiest ways to avoid this problem is to implement a split database, which is less prone to corruption.  Nothing is worse than having a user corrupt your backend data!

10: It’s easier to get individual users back on track
Security in the front end is one way to limit user interference. However, some users require more flexibility than others and there are always trade-offs. Some applications will require tight front-end security, while others will allow more freedom to tinker.

When a user tinkers to the point of destruction, a split database is easier to repair. Rather than bringing the entire application and all its users to a screeching halt, you have only one user who’s unable to work, momentarily because they broke their specific Access frontend and not the entire application. The fix is usually as simple as recopying the front end and overwriting the changes that the person made.

I hope this was helpful to people who have an Access application at their business.  If anyone is looking to learn more about our Remote Desktop and or SQL backend hosting options, please do not hesitate to contact us or sign up for a free trial to try it for yourself.

Posted in Access 2003, Access 2007, Access 2010, Access 2013, Remote Desktop, Remote Desktop Hosting, SQL Hosting, Tips & Tricks | Tagged , , | 1 Comment

Remote Desktop Storage Upgrade for 2015

Access Hosting is proud to announce that for 2015 we have increased the storage quotas on all of our Remote Desktop Hosting plans for customers seeking an easy way to move their Access Hosting Database to the web without any modifications.

Access Hosting, the leading hosting company for Microsoft Access services and solutions has doubled and tripled the storage on their Access Remote Desktop plans. Customers in need of bringing their Microsoft Access web application to the cloud can now do so without the need for expensive hardware or costly setup.

Interested customers will now enjoy 2GB of storage with the $29/month Access Pro Virtual Desktop and 3GB of storage with the $49/month Office Pro Plus Remote Desktop plan. Anyone interested in trying out this hosting service can sign up for a free 30 day trial at http://accesshosting.com/remote-desktop-hosting/free-trial

Remote Desktop Services allows you to keep your Access 2007, 2010, or 2013 Database running “as-is” online in the cloud. Using the latest advances in Microsoft Hypervisor technology we can create a seamless single click operating environment for your existing Access database that allows you to run your application without modification. This approach allows multiple users to connect concurrently to the cloud from any PC and experience the program as if it was running locally on their desktop. Pricing starts at just $19/month and we offer a free trial for qualified customers.  You can learn more at http://accesshosting.com/remote-desktop-hosting/

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

Check Our Access Database Uptime on Access Hosting

hosting server uptime graphic

We recently stumbled onto a great uptime monitoring service to better service all of our access database servers and customers. This service will let you easily check if your Access web databases are online and available on both our SharePoint Access Services plans and our Remote Desktop hosting plans. This is a great tool for us to make sure that our uptime is to our high quality standards of 99.9% and for you to check if the problems that you are experiencing are just related to your username or Sharepoint site or is a wider issue for everyone on the server.

You can view our SharePoint Access Hosting Uptime here

You can view our Remote Desktop Uptime here

Posted in Access Runtime, Remote Desktop, Remote Desktop Hosting, SharePoint 2013 | Leave a comment

Our new Starter Plan includes OpenOffice

2013-02_Apache_OpenOffice_Logo-Proposal_ChrisTa

Access Hosting is proud to announce the availability of Apache OpenOffice on our low cost Remote Desktop Starter plan. The $19/month plan is now loaded with a great collection of free and productive business software from the MS Access runtime to Adobe Reader and OpenOffice. Apache OpenOffice is the leading open-source office software suite for word processing, spreadsheets, presentations, graphics, databases and more. It is available in many languages and works on all common computers. It stores all your data in an international open standard format and can also read and write files from other common office software packages.

You can get started testing out OpenOffice and our Access Remote Desktop by signing up for a $19/month free trial.

Posted in Access Runtime, Remote Desktop, Remote Desktop Hosting | Tagged , , | 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

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

Setting up the Microsoft RDP connection for the iPad and iOS 7

This short video will step through the process of creating an RDP connection on the iPad



Posted in Access and the iPad, Remote Desktop Hosting, Video Tutorial | Leave a comment

Why is my database blank when I upload it to the Remote Desktop?

Problem: I just uploaded my database to remote desktop and when i open it, I get a blank Microsoft Access page

We have received a lot of these support tickets lately for users that have signed up for the RDP starter plan.  Remember that the starter plan does not include the full version of Access – but rather the Access Runtime. The Runtime does not have the same feature set as the full version of Access.  One of the differences, is that it lacks the left-side navigation to jump between forms making it essential that you set a start-up form in your Access Database BEFORE uploading it to your RDP Starter plan.  Developers often create a home navigation form that allows users to jump around within a runtime app but as long as you have set some kind of start-up form, when you upload your database it will not be blank when you open it on the RDP Starter Plan.

How do I set a Startup Form in my Access Database?



Of course, if you would like to use the Full Version of Access – you can sign up for a Free Trial of our Access Pro plan here.

Posted in Access 2007, Access 2010, Access Runtime, Remote Desktop, Remote Desktop Hosting, Video Tutorial | 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 | 1 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

Announcing Excel 2013 Power Business Intelligence Hosting

excel2013 power view

Access Hosting is proud to announce our new Excel Power Business Intelligence Hosting for only $99/month.  This new plan combines the flexibility of our Remote Desktop hosting solutions with the power of SQL server hosting.  This powerful solution is possible NOW without the expense of Office 365 or a SharePoint server and allows for substantial business insights through PowerPivot and Power View.

excelpowerbi

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. Power View is a powerful feature of Microsoft Excel 2013 that can be utilized in ANY HTML5 compatible web browser with our Power RDP technology.

You can learn more about this product and sign-up for a 30 Day Free Trial of Excel 2013 Hosting here.

Posted in Excel 2013, Featured, News, Remote Desktop, Remote Desktop Hosting | Tagged , , , , , | Leave a comment

Does Remote Desktop Hosting work with Macintosh

8-1-2013 4-20-10 PM

Absolutely! you can user our Virtual Remote Desktop hosting on your Mac and a slew of other devices.  Windows PCs come with the Remote Desktop Protocol preinstalled and if you have a Mac with Office, you’ll have RDP installed already.

If you don’t have Office for the Mac, you can download the RDP client for Mac for Free.  You can learn more about the Mac OSX RDP client from Microsoft here: http://www.microsoft.com/mac/remote-desktop-client

or download it directly from here:

http://www.microsoft.com/en-us/download/search.aspx?q=microsoft%20remote%20desktop%20connection%20for%20mac&p=0&r=10&t=&s=Relevancy~Descending

Posted in Remote Desktop, Remote Desktop Hosting | Tagged , , , , , | Leave a comment