Data Center & Security
Our data centers are world-class facilities with carefully selected locations that provide a redundancy and top of the line security.Do you have questions or need help?
If you need help selecting the right hosting plan or have a Sales question, please chat with a Access Hosting Sales Operator
Sales: (302) 468-7475
Get your questions answered by watching some of our Video Tutorials. Get help 24/7 from our Helpdesk and Forums
Visit our Help Desk-
Tag Archives: Access 2010
5 Unconventional Ways Microsoft Access Can Power Your Business
Since it’s inception, Microsoft Access has been the go-to database for businesses of all shapes and sizes. Not surprisingly, as Access’s features and cloud capability have rapidly expanded over the years, so too have the different ways the technology is used. Here are a few of our favorites:
1. Employee Training
There are few things more valuable to a business than properly onboarding and training new employees. While for most companies the ROI on hiring and app developer for a training application wouldn’t be high enough to justify the cost, building them in house is an appealing option. And as the company’s hiring scales, moving the backend of the app to a server like Microsoft SQL Server will be a low-cost way to scale your training app with it.
2. Customer Relationship Management
For many small businesses, CRMs like Salesforce or Microsoft Dynamics are either too expensive or too cumbersome to implement. However, having accurate, up-to-date customer and prospect information is crucial to running client-facing departments . As an MS Access user, it’s more than likely that much of this data already exists there. By standardizing this information and creating relational tables for objects like leads and deals, you too can have a CRM without the cost and learning curve.
3. Displaying Access to Data
While we’re on the subject of prospects and customers, many of them will want to access some of the data that you store in your web database – for example, recent invoices or the date of their next appointment. You can easily deliver this data easily by offering them a form they can fill out on your site. ASP.NET forms can query a Microsoft Access online database directly, so by implementing them on your site, you can surface this data to your customers with limited effort from your developers.
4. Business Intelligence
If you’re like many, you’re using an endless string of VLOOKUPs in Excel to report on related data from different tables or sources. This is really a job for Microsoft Access’ relational tables. Built on top of Microsoft’s Jet Database Engine, you can use these powerful tools to easily create queries that quite literally fly.
5. Development Waterfalls
If you’re in software development, one common practice you’re likely familiar with is creating waterfall models to manage the progress of an application. Since you may be creating an application that leverages Access or SQL Servers as your backend, why not keep track of your app’s progress there as well?
These are just a few of many ideas for uses for MS Access – the beauty of the software is that it’s uses are really only limited to the imagination<.
Posted in Access 2010, Access 2013, Access 2016, Access Developer, blog, SQL Hosting, SQL Server 2012
Tagged Access 2010, Access 2013, Access 2016, Access on the Web, Microsoft
1 Comment
3 Great Reasons to Choose Microsoft Access
The database market is divided among four major players: MS Access, Oracle, SQL Server and MySQL. Due to accessibility and focus on user interface, MS Access has garnered some negative press as being unsuitable for professional level database development. However, depending on the needs of the organization, there are many compelling reasons to choose MS Access as your business database software.
1. It’s widely distributed
MS Access is bundled with the MS Office suite, making it the most widely available desktop database program in the world. This also makes it one of the most affordable options for businesses, which tend to purchase businesses licenses of MS Office. The common interface among all the MS Office programs makes it easy to import and move data to and from the database without having to resort to specialized software. Due to the popularity of the product, support for MS Access is also very good, with plenty of online tutorials and articles available, in addition to Microsoft’s excellent customer service.
2. It’s user-friendly yet powerful
One of the main benefits of MS Access is its ease of use. Even users new to database development can pick up the basics quite easily, as everything is presented in an intuitive manner. Much of the user interface in MS Access is designed to assist users with creating and editing tables, and there are many templates available to ensure that the database meets organizational needs. MS Access also provides options for importing data from other databases, and provides troubleshooting tips for every step of the way.
Despite this focus on ease of use, MS Access users have access to powerful SQL tools that allow for rapid development. MS Access is also .NET friendly, meaning that developers wanting finer control of software development can take advantage of the ease of use and functionality of MS Access.
3. It has excellent third-party support
Due to the widespread popularity of MS Access, there are many third-party plugins and developmental tools that are available. This means that MS Access is far more flexible than other databases, making it easier to customize and adapt to the changing needs of your business. In addition, there are many more external consultants well-versed in MS Access, and they are generally more affordable than consultants for Oracle and SQL Server.
MS Access is an excellent database choice if your organization requires a database that is easy to use and that has established, reputable support structures. MS Access is powerful enough to meet the demands of most small to medium businesses.
Best of all you can utilize Access Hosting superior hosting infrastructure to further bolster your Access Database and get it in the cloud easily and securely. All of our services offer a free 30 day trial so that you can easily test everything with Microsoft Access to make sure that it meets your needs.
Posted in blog, News
Tagged Access 2010, Access 2013, Access 2016, Access on the Web, Remote Desktop
Leave a comment
MS Access: How to Create Query Joins
The foundation for any database software, like MS Access, is the ability to send a query. Organizing information and making it accessible on demand is what makes database software so powerful. Understanding how to craft queries can be challenging at first, but once you understand how to use select, action, parameter and aggregate queries, then you’re on your way to expertise. For truly complex queries and more complete data sets, you need to understand what query joins are, what they do and how they work.
Types of Queries
When working with an online database, there are four basic types of query joins: inner, left, right and full. These descriptors tell you where the web database is looking for the requested information.
- Inner – An inner-query join allows you to search both tables and get results that match the query from either of the tables.
- Left – A left-query join returns results that match the query from the left table and all matching rows from the right table.
- Right – A right-query join works the same as the left join, but it uses the right table as the starting point.
- Full – A full-query join returns any results where there is a match in one of the tables.
Exploring the “Join Properties” Dialog Box
When creating join queries, you must first create joins between tables and relationships between fields. When the “Join Properties” dialog box pops up in the Access web app, you will see three sets of options:
First, you will need to select the left and right tables you want to join. There will be a drop-down list with all of the available tables. Designate the first one you want to work with as the left table and the second as the right table.
Next, you will need to select the columns to look at for each query. This allows the database on the web to only search for information in relation to those columns. There will be a drop-down list with all of the column names available. Select the column on the left and right tables you will be working with.
At the bottom of the dialog box are three options. These options are for creating a left, right or inner query. Select the type of query you want to use and move on to creating output fields.
Using join queries effectively allows you to do things like segment your mailing list for targeted marketing, find customer accounts more quickly and accurately, build customized reports and more.
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/
Preparing your Access database for the web
Have you considered running your Access Database on the web with Sharepoint and Access Services?
Access Services does not support all the data types, relationships, objects, or events that the full Access client provides. If you’ve created a web database from the start, only the supported elements will be shown during the design process. For those who have not created a web database from scratch, it is still possible to get your regular Access database up to the web with Access Services.
Access 2010 includes the “Web Compatibility Checker” tool. This tool checks the web compatibility of the tables in a database as well as web objects. However, the tool does not check any data within the actual tables and does not check linked tables from other data sources.
The goal of this tool is to make sure that the database is “web-legal” and to get you up and running with Access Services in a functional manner.
To run the Web Compatibility Checker tool in Access 2010:
1. Go to FILE > Save & Publish
2. Click “Publish to Access Services”
3. Click “Run Compatibility Checker”
Once you’ve completed this process and fixed any errors, the next step is to get the database up to a Sharepoint server. You can get up and running with a Sharepoint 2010 Enterprise server for as low as $49 per month from AccessHosting.com
Posted in Access 2010, Access 2013, Sharepoint 2010, Uncategorized
Tagged Access 2010, Sharepoint
Leave a comment
How Access Services 2013 has changed since 2010 and what that means for Access Developers
One of the most important changes with Access 2013 and their new web apps is in the architecture itself.
In SharePoint 2010, Access Web Services was storing everything in SharePoint (and then SharePoint’s content was backed up by SQL). Access 2013 apps are hosted by SharePoint 2013 while the data is stored in SQL Server 2012. SharePoint 2013 provides authentication, authorization, and security for Access 2013 apps. The back-end tables, views, macros, and queries are stored in an SQL Server 2012 database. This change in architecture reflects a substantial change in the way Access Services works.
You will notice that SQL stores tables, views, macros and queries but there’s no mention about reporting. That is because Access 2013 Web Apps do not allow you to create traditional Access reports. The only way to do reporting is by connecting the local Access software program to the SQL tables directly or using some other compatible reporting software tool.
There are a lot of advantages of using Access 2013 with SharePoint 2013, but it is important for Access Developer to note the following:
- The idea of the Hybrid Application, SQL reporting services in a browser, and the architecture of Access Web Services 2010 has been completely abandoned by Microsoft. Access Applications can be either SharePoint 2013 web apps OR traditional local Access Applications.
- Any existing SharePoint 2010 web application cannot be moved to SharePoint 2013. You can preserver your tables, but all of your forms, reports, and queries will be lost in the transition from SharePoint 2010 to SharePoint 2013.
- Access 2013 introduces a new application type that enables you to create a web-based Access app in SharePoint 2013. It is easier and more stable than 2010 since it is directly backed by SQL, but there are no built-in reporting services for Access web apps.
- Access 2013 and Access 2010 can both publish to SharePoint 2010 and the old Access Web Services 2010. You must have Access 2013 to publish to SharePoint 2013 and create an Access 2013 web app.
- VBA code is not compatible with SharePoint 2010 or SharePoint 2013 Access applications.
Access Hosting is committed to supporting the Access Developer community and will continue to offer SharePoint 2010 Access Web Services hosting for as long as developers are interested. SharePoint 2013 Access Web apps do have a ton of advantages, and we have launched our brand new Access 2013 SharePoint 2013 hosting packages. If you are interested in a free trial, please sign-up here.
We don’t just offer SharePoint hosting either. We have great ways for every Access Developer and Access application to be hosted in the cloud whether it’s through SharePoint, SQL Server or our RDP solution which lets you host any Access 2007, 2010 or 2013 application without ANY modifications. It supports VBA code too.
Posted in Access 2013, Featured
Tagged Access 2010, Access 2013, Access on the Web, sharepoint 2010, sharepoint 2013, SQL Server 2012
Leave a comment
Remote Desktop Virtual Appliance NOW only $10 per User!
We are happy to announce that our Remote Desktop Virtual Machine has undergone some price changes and is now cheaper than ever. Our RDP Virtual Appliance is only $299/month and comes with 4GB of RAM and up to 10 users. Access 2010 or Access 2007 will come pre-installed on every remote desktop. With RDP, there are absolutely NO CHANGES necessary to your Access Application to get it running in the cloud. Simply copy/paste it over to your Remote Virtual Desktop.
Additional users are now only $10 per month! and the entire Microsoft Office suite (Word, Excel, Outlook, and Powerpoint) can be added to any virtual desktop for only $10 per user per month! These plans come with No setup fee and NO long term commitment. Best of all, you can install your own software and completely customize your RDP environment.
© 2010-2019 Access Hosting LLC. All Rights Reserved | Sitemap | Privacy Policy | Acceptable Use Policy | Terms of Service
Microsoft ®, SharePoint ®, and Windows ® are all trademarks of Microsoft Corporation