Data Center & Security
Do you have questions or need help?
Latest Blog Posts
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.
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.
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.
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.
Microsoft did not bite off any major changes between Access 2013 and 2016. Nothing major changed (like the move from Web Databases to Web Apps from 2010 to 2013) and there are mostly just some enhancements and more robust design options. Here are some of the features outlines by Microsoft:
Do things quickly with Tell Me
You’ll notice a text box on the ribbon in Access 2016 that says Tell me what you want to do. This is a text field where you can enter words and phrases related to what you want to do next and quickly get to features you want to use or actions you want to perform. You can also choose to get help related to what you’re looking for.
Can’t find a button? Click inside the Tell Me box (it’s the box at the top, with the light bulb). Type a button or command, like “filter”, and you’ll see all of your filter-related options listed for you.
Keep in mind that the the Tell Me box is not available in the ribbon when designing Access web apps.
Export linked data source information to Excel
Have you ever wanted to get a nice list of all the linked data sources from your Access database application into MS Excel? If you are working on a complex Access application, for example, that includes links to many different data sources, it can be helpful to have a nice list of all the various data sources and their types. This exported list can be especially helpful if you are working on an Access application you did not originally design. Now with Access 2016, you’ll find this task much easier using new functionality built into the Linked Table Manager dialog.
Open the Linked Table Manager dialog by clicking External Data > Linked Table Manager. Select the linked data sources you want to list and then click Export to Excel.
Once again, please note that this feature is not available when designing Access Web Apps. Are you seeing a trend here?
Larger Show Table dialog
In Access 2016, the default height of the Show Table dialog has been increased so you can easily see more table and query names in your database.
To view the Show Table dialog in queries, click Create > Query Design. The Show Table dialog opens by default. You can also open this dialog in queries by clicking Design > Show Table. To view the Show Table dialog in the Relationships window, click Database Tools > Relationships. The Show Table dialog opens by default. You can also open this dialog in the Relationship window by clicking Design > Show Table.
Once again, please note that the Relationships window is not available in Access web apps.
New visual themes and templates for the Access program
As mentioned a lot of the improvements to Access 2013 come to aesthetics. There are now two Office themes that you can apply to the Access program: Colorful and White. To access these themes, go to File > Options > General, and then click the drop down menu next to Office Theme.
If you want to organize and manage your data with Access but you’d like some help getting started with designing the database, try using a desktop database template. In Access 2016, five of the most popular database templates have been redesigned to have a more modern look and feel. To try these templates out yourself, go to File > New, and then search for any of these:
Each of these templates includes a new Getting Started form with links to articles, videos, and other community resources.
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.
We have been getting tons of requests from Access developers and DBAs about SQL Server 2012 (previously known as “Denali”) that need multiple databases and other more robust SQL 2012 options. Today we are pleased to announce the availability of Microsoft SQL Server 2012 Web Edition for $199/month.
This is the latest installment of Microsoft’s popular database and it includes a number of improvements over previous versions. New improvements SQL 2012 include AlwaysOn for higher availability, Contained Databases to improve on some of the authentication challenges associated with moving databases and FileTables for those apps that manage unstructured data that lives as files outside of the database.
Of course the big advantage of this plan to Access Developers is the ability to create an unlimited number of tables, databases and SQL user logins so that you can manage multiple clients, databases, projects and Access applications from the same secure cloud-based location. If you have any further questions, please check out our SQL 2012 webpage and feel free to chat online with a sales representative or contact us via email.
Access 2013 requires the SQL 2012 Native Client in order to run reports against a 2013 web application that has been published to SQL 2012.
You can download the 32 and 64 bit version of those files here.
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
here is the Access 2013 Quick Start Guide with tutorials for MS Access 2013:
As part of the January 2013 patch cycle Microsoft has introduced an update for Access 2013. You can use Windows Update or direct download to update your system and both 32 and 64 bit verisons are available. What does this patch accomplish ? The KB article alludes to to “stability and performance improvements” without any additional details.
Here is a screenshot of an unpatched system:
And after the patch is applied:
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:
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.
Start the new year by reviewing the dramatic improvements to Access and Access Services in SharePoint 2013. This 8 page document will step you through some of the biggest differences between Access 2013 and Access 2010.
What’s New In Access 2013
If you like what you see go ahead and sign up for a free trial of our Hosted Access Services 2013, Remote Desktop 2013, or SQL 2012 solutions.
Here is a short video that shows how to configure Internet Explorer so that hosted Access Web Databases do not require multiple logons to the SharePoint 2013 site collection. If you are getting repeated requests to logon to your SharePoint 2013 site while working with Access 2013 this video is for you.
If you are just getting started with Access Web Databases on SharePoint 2013 and wondering where to begin this video is for you:
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.
We are happy to announce that all of our existing SQL 2012 server customers (and any new SQL customers) now have 10 times more storage with our basic plan. Our basic SQL 2012 Server hosting comes with 10 GB of storage space. This package is perfect for enterprise level Access Databases that need to have their data tables securely hosted in the reliable SQL database environment. This package has been priced to be incredibly competitive with Windows Azure and unlike Azure has no bandwidth limits/surcharges. It’s simply 10GB of SQL 2012 Server Storage and hosting for $49/month.
Now is a great time to give our SQL 2012 Server Hosting with our free 30 day trial.
We have partnered with the Access Experts to offer our SQL 2012 Hosting Service. Check out this video tutorial on some advanced code techniques that would be compatible with our SQL or RDP hosting:
Learn advanced techniques on Microsoft TempVars, Enums and Classes. Presented by AccessExperts.net, Access Experts specializes in creating Access applications for clients in the US and Canada.
When you first boot up the Access 15 Public Preview, you will be greeted with the option to create a blank web database, a blank desktop database or select one of the Desktop or Web templates that are available. It is interesting to note that databases now seem to be either Desktop or Web applications. I was not able to get any of the web templates or even a blank web database to load. It appears that you have to be connected to a hosting service or something to get this to work at all.
I was able to load up a Desktop template and while Access 2013 does feature a spiffy new Metro interface, the standard desktop features that everyone has come to expect in Access seem to all be intact.
The ribbon in this new version of Access 2013 is laid out nearly identical to Access 2010. Everything seems to be located in an easy to get to place and any users of Access 2010 should feel pretty at home even with the new Metro styled interface.
The free public preview of Office 15 just became available. Interestingly enough, they’re calling it: Office 365 Home Premium Preview. After downloading a very small install exe file, you’ll go through a few steps and be greeted with this opening video for the suite of products:
We’ll follow up with some impressions and videos of Access 15 in the coming weeks.
This video tutorial answers the common question that we get about printing from a Remote Desktop hosting session. In this example, we print from Microsoft Access 2007 to a PDF file which we can then copy/paste and download to our local desktop computer so that we can print to any locally connected printers or network printers.
We are proud to introduce a streamlined and cheaper RDP Virtual Appliance Hosting options for only $299/month. To learn more about this new product visit our new webpage.
Windows Remote Desktop Services is a powerful way to access your company information, files and databases from anywhere with an available internet connection. Remote Desktop users that purchase one of our dedicated virtual servers can run all of their company software (Microsoft Office, Access Databases, Accounting Software, etc.) online instead of from their local hard drives. Our Windows RDP Virtual Appliances have dedicated resources for each customer which guarantees system performance, absolute security, and access to everything from anywhere. The Best part is that the cost is fixed per employee and paid monthly.
Purchasing a remote desktop dedicated hosting plan offers much more flexibility and control than our shared plans. All of our virtual appliances allow for administrator access that will let you customize your remote desktop environment and install your own corporate software and programs. More importantly, our hosting plans will save you money on costly servers, network maintenance, IT support, and bandwidth charges. Because we charge monthly per head, whether your business shrinks or grows your IT costs will always stay in line with your operation. No risky overspending, and no unexpected costs should you suddenly need to expand.