- #Microsoft access database hosting how to#
- #Microsoft access database hosting for android#
- #Microsoft access database hosting Pc#
And, again, if you have a hosted server (above) online, your Workspaces virtual PC can connect to it.
#Microsoft access database hosting for android#
You can access it anywhere through a web browser and they also have apps for Android and iOS. If you don't want to keep a PC running around the clock, Amazon Workspaces allows you to set up a virtual PC running Windows and Access.
You can connect with any PC, Android, or iOS device with Chrome Remote Desktop. If your users already have desktop PCs that are running your database, they can connect to them remotely.
#Microsoft access database hosting how to#
In my Access on a Phone video, I show you how to connect to your Access database using remote connectivity software. SQL Server gives you much more room for growth in the future. I've got full-length seminars that walk you through setting up each, so don't be too concerned with either being difficult. SQL Server gives the best overall functionality, and is usually the better choice, in my opinion. SharePoint is a little easier to configure, but not by much. If, on the other hand, you may have people outside your organization use your database (consultants, outside sales reps, vendors, customers, etc.) OR you're planning on having some of your data accessible by a website interface, then you should consider SQL Server.īoth are roughly the same in terms of cost to setup and maintain. If you're working with a small team of trusted people (employees of the same company, for example) and you already have a SharePoint site set up between yourselves, and you're not planning on doing much with outside users or putting your data up on a web site, then SharePointis just fine. SharePoint or SQL Server?Īs far as whether to choose between SharePoint or SQL Server, that all depends on who needs to access your data. You can get set up for less than $10/month. I find that this is the best solution available for teams of users (employees of a company, for example), plus using ASP(below) you can make your SQL Server data public on your web site. Best of all, SQL Server hosting through companies like WinHost is real cheap. You can just get the free Access Runtime Edition. Your end users need a copy of Access installed, but you don't have to buy Access for each of them. Access SQL Online Seminar - Recommended.The benefit of this method is that you get to use your actual Access database as it is now, and you can just move your tables up to SharePoint or SQL Server. If all of your users are working on desktop PCs (or laptops) with Windows and copies of Access, then I recommend using an Access database front-end file (a database that contains your forms, reports, code, etc.) attached to a Microsoft SQL Server or SharePoint to get the data. I've been getting this question a lot lately: "How can I put my Access database online so other people can use it?" There are several different things you can do to put your database online, depending on who your users are, what kind of security you need, how much work you want to put into development, and what you want the end-result to look like.
0 kommentar(er)
