<div>
Access with ACE as the database engine was never designed to run over the internet. &nbsp; With that said, using SQL server, you can do that. <br />
<br />
&nbsp;But your success relies on how the app was developed. &nbsp; If not with client/server in mind, then you won't be happy. &nbsp;Azure is basically SQL Server in the cloud, so the tips here:<br />
<br />
<a href="https://www.jstreettech.com/downloads.aspx" rel="ugc">https://www.jstreettech.com/downloads.aspx</a><br />
<br />
In &quot;Best of both worlds&quot; applies. &nbsp; That's a start anyway.<br />
<br />
Also, you'll want to re-factor the app to push as much work server side as you can. &nbsp;That means using Stored Procedures, Views, and Pass-through queries as much as possible.<br />
<br />
You want to be minimizing the data going over the wire as much as possible, which requires a different mindset and development over that of a typical Access app. &nbsp; not that it can't be done and done well, but developing for client server use is different.<br />
<br />
Jim.
</div>


Jeff Everett

<div>
By using an Azure db with an Access frontend you are creating a Hybrid database. &nbsp;As Jim stated it is the same idea as using SQL Server for a backend. &nbsp;One critical thing is never bind objects to a table, but rather only pull individual records at a time. &nbsp;You want to minimize the amount of data being pushed/pulled through your internet connection. &nbsp;I open my form with a recordsource that always returns nothing, then allow the user to make a selection and then return that specific record.<br />
<br />
Jack Leach has a few quick articles that may help <a href="https://dymeng.com/azure-series-01-intro-to-azure/" rel="ugc">https://dymeng.com/azure-s<wbr />eries-01-i<wbr />ntro-to-az<wbr />ure/</a><br />
<br />
Switching to SQL Server or Azure by no way garantees any performance improvement. &nbsp;In many cases, things actually slow down because application weren't design with such a back-end over a WAN in mind.<br />
<br />
Whenever someone talk to me about an Internet database, I always tell them to use proper web technologies: PHP, .Net, MySQL, ... I just finished a major conversion for a client from an Access db to PHP/MySQL because of too many issues with O365/Win10 bugs and limitations with Access and a hybrid database could never come close to the performance that I get with PHP/MySQL. &nbsp;Added bonus, no software required beyond a web browser!
</div>


<div>
Generally your options are:<br />
1. You host your application on Azure instance...you are utilising it via RDP(RemotApp)..you get as good performance as good as &nbsp;your underlying instance specs... negative ..you need RDS infrastructure (everything is on a single instance)..and of course costly Terminal client licenses..<br />
2. You move your BE to Azure but on a 3rd party engine like Sql server, MySql..etc...the performance now can boost even more as SQL makes far greater resources handling... negative .. complexity and requires quite a bit of coding/optimization..etc..<wbr />big plus..NO licenses..and if the migration is &quot;good&quot; ...you will get stellar performance.<br />
3. other options like VPN and drive mapping are ...slow....
</div>


<div>
Jim, thanks for the link to my slide deck.<br />
<br />
Daniel, we bind Access forms to SQL Azure tables and views all the time. &nbsp;It works fine if you keep the number of records (using the Where clause) and fields (not specifying Select *) to a minimum, and let SQL Azure do as much of the processing as possible.<br />
<br />
Many businesses don't have the budget to rebuild the entire thing as a web application, when moving the back-end to the cloud will give them an acceptable system for much less money.
</div>


<div>
@Jeff,<br />
<br />
&nbsp;
<blockquote>
feedback or a good tutorial on taking an existing Access Database and hosting it on an Azure instance, 
</blockquote>
<br />
&nbsp;Just to be clear on this, is it that you just want to host the database in the cloud, or host the entire app in the cloud?<br />
<br />
&nbsp;John's comment relates to the latter, while everyone else is talking about the former.<br />
<br />
Jim.
</div>


<div>
HI guys, <br />
<br />
@JimDettman - My hopeful scenario would be to host as much as possible on the Azure side and run Access locally on laptops. &nbsp;My friend is presently building the web application and its going great but... My client just needs a mandatory quick short term solution to speed things up because its digging into productivity like you read about. &nbsp;The database is taking minutes at times to propagate because they are running it on a laptop and then all of them try to update in real time. Its a mess! I learned more today about their setup so, the quickest and easiest solution (which I know is subjective) is my goal. by the way forgive me... Access is not my wheelhouse and this is the 1st time I'm attempting anything like it, why I reached out to EE experts! &nbsp;Sorry for my late response its a day of meetings. Thanks Jim and everyone!
</div>


<div>
Like Armen, I have several clients who are using Access FE with Azure BE. &nbsp;I'm rewriting parts of one of those to take advantage of the server side issues mentioned by others here, the other one was designed from the get-go with SQL Server in mind so it did not need much updating.<br />
<br />
You might want to look at your customers internet connection as that is probably point which is causing the greatest delay. &nbsp;If they don't have at least a 1GB pipe between their servers and their Internet Service Provider, that is where they need to start.<br />
<br />
Dale
</div>


<div>
Hi Dale, I disagree on needing that much speed if the Access FE is optimized correctly. &nbsp;The whole point is to not have that much data moving across the wire. &nbsp;We have applications that work just fine on slower connections.
</div>


<div>
Armen,<br />
<br />
I don't disagree, but it doesn't sound like the OPs Access db is optimized at the moment, so the quickest thing to work with would be band-width. &nbsp;and going from 100Mb to 1Gb on an internet connection might not be overly expensive. &nbsp;with Verizon FIOS, the difference is only about $30/month.<br />
<br />
Dale
</div>


<div>
If its done correctly you can have very good output with slow -slow connections..<br />
Take a look at my <a href="https://tsgiannis-gmail.tinytake.com/sf/MjEwNzg4NV82NjAyNzYw" rel="ugc">demo </a>...(14-15 Mpbs simple ADSL line with 50ms latency...the good old days when my connection was at least decent...now its only 10+mbps as Greece likes to go back in time ) ...about 100+colums/1000 rows (not my design)..not to forget single core VPS with 1 Gb Ram running MySQL
</div>


<div>
Thank a ton everyone for your feedback! The client decided to go with a web app and bypass Azure all together. I learned a whole lot on during this ordeal. . Although Azure seemed to be one of the quickest solutions, for long term this big chain corporate juggarnaut wanted a more scalable solution. Azure also required outside resources and more hands in the pot werent a good thing here. &nbsp;Thanks again everyone!
</div>


<div>
*Is there a way to award everyone for their feedback here? The solution in my opinion was combination of everyone's comments to come to the conclusion that we alleviate Azure for the process. :D * &nbsp;Have a great day everyone!
</div>


<div>
@Jeff,<br />
<br />
Each one of the posts should have options for &quot;This is the solution&quot;, &quot;This is helpful&quot;, and &quot;This is not helpful&quot; at the bottom of each post. &nbsp;You should be able to mark each post with one of those three (although I generally don't use the &quot;not helpful&quot; option. &nbsp;Additionally, you should be able to select multiple posts as &quot;This is helpful&quot;.<br />
<br />
Dale
</div>


<div>
<div class="content wysiwyg-content">
Hello everyone! I am wondering if anyone has any guidance, feedback or a good tutorial on taking an existing Access Database and hosting it on an Azure instance, or another short term solution to help speed issues over the internet? We have approval to attempt it ourselves because the speed of the present database, being hosted on a laptop is SUPER slow and basically destroying productivity! &nbsp;Its my 1st attempt at this type of Azure instance so any start to finish feedback is welcome.
</div>
</div>


Hello everyone! I am wondering if anyone has any guidance, feedback or a good tutorial on taking an existing Access Database and hosting it on an Azure instance, or another short term solution to help speed issues over the internet? We have approval to attempt it ourselves because the speed of the present database, being hosted on a laptop is SUPER slow and basically destroying productivity!  Its my 1st attempt at this type of Azure instance so any start to finish feedback is welcome.

Access Database hosted on Azure or similar to help with present speed issues over the internet.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.