Data Center & Security
Do you have questions or need help?
Latest Blog Posts
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.
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
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.
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.
Create a Login Form from the Dialog form design. Then customize the form to your liking.
Create two text boxes in the Login Form as txtUserName with label Login Name and txtPassword with label Password
Under the “On Click Event” of the Cancel button, add the Embedded Macro with a QuitAccess command to exit the program or Access application
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
If you have any questions, please do not hesitate to contact our technical support team: http://support.accesshosting.com
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:
3. Click connect and then enter your login credentials. Your username prefix should be used as the domain.
4. Click OK to connect to the Windows Server and your RDP hosting environment.
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.
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.
If you have any questions or specific backup needs, please contact our technical support team.
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):
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.
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/
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.
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.
Running your Access application on the Kindle Fire can be accomplished in just a few simple steps.
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:
Click your settings tab
Navigate to Applications
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.
3. Pin the newly installed Microsoft Remote Desktop application to your home screen
4. Configure the Remote Desktop Connection. If you are using our Remote Desktop Hosting Service this information will be provided via email.
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.
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:
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.
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.
This short video will step through the process of creating an RDP connection on the iPad
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.
USE AN ACCESS 2013 APP IF …
USE AN ACCESS REMOTE DESKTOP DATABASE IF …
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.
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.
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.
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.
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: