Re: [MSAccessProfessionals] Migrate MsAccess Frontend with SQL Server Backend to Azure

I did not set it up but I believe it was the VM option. I could remote to the server using RDP or ScreenConnect and then run SSMS on it directly (normally I just use SSMS from my desktop to work with it). It was definitely not the single database option as we have multiple databases on the instance. 

I'll add that they have a very robust Internet connection in the office, so it wasn't a case of a slow connection.

Paul

------ Original Message ------

From: "drnorbert2002 via groups.io" <drnorbert=msn.com@groups.io>

To: MSAccessProfessionals@groups.io

Sent: 1/21/2026 3:30:46 PM

Subject: Re: [MSAccessProfessionals] Migrate MsAccess Frontend with SQL Server Backend to Azure

Paul, quick clarification — when you say your employer moved to Azure, were you using Azure SQL Database (PaaS) or SQL Server running in an Azure VM (IaaS)?

I'm trying to understand whether the issues you saw were more related to cloud latency in general, or specific to Azure SQL's PaaS constraints.

Thanks,
Norbert

Re: [MSAccessProfessionals] Migrate MsAccess Frontend with SQL Server Backend to Azure

Paul, quick clarification — when you say your employer moved to Azure, were you using Azure SQL Database (PaaS) or SQL Server running in an Azure VM (IaaS)?

I’m trying to understand whether the issues you saw were more related to cloud latency in general, or specific to Azure SQL’s PaaS constraints.

Thanks,
Norbert

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116744) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Report Not Working

David

Windows 10 had quite a run with printing problems for over a year. Check to see if the Win 10 computers are fully updated.

 

Regards,
Bill Mosca,
Founder, MS_Access_Professionals

MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog

https://wrmosca.wordpress.com

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of David Pratt via groups.io
Sent: Wednesday, January 21, 2026 9:51 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Report Not Working

 

I went to the Win 10 computer and changed the default printer to Microsoft PDF printer and it solved the problem. It was on ''let Windows set the default". And as far as I know, it has been on let windows choose for years, but maybe I am wrong. Anyway, with the default set to MS PDF, the Access app works once again.

 

The two Win 11 computers on which the app works are both set to let Windows choose default printer.

Re: [MSAccessProfessionals] Report Not Working

I went to the Win 10 computer and changed the default printer to Microsoft PDF printer and it solved the problem. It was on ''let Windows set the default". And as far as I know, it has been on let windows choose for years, but maybe I am wrong. Anyway, with the default set to MS PDF, the Access app works once again.

 

The two Win 11 computers on which the app works are both set to let Windows choose default printer.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116742) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Report Not Working

Have you tried putting a "fresh" copy of the database on the Windows 10 computer? I'm assuming your database is separated into a front end and back end and the users have an accde front end.  I have found sometimes a user's accde file gets corrupted and a fresh copy fixes it up. 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of David Pratt via groups.io
Sent: Wednesday, January 21, 2026 11:30 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Report Not Working

 

Thanks for taking the time to reply. I dont think the issue is with my Access file but instead is with the OS or computer settings. I was able to verify this by installing the app on a third computer (Win 11) and the app works as it has for

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

Thanks for taking the time to reply.  I dont think the issue is with my Access file but instead is with the OS or computer settings.

 

I was able to verify this by installing the app on a third computer (Win 11) and the app works as it has for the last several years.  I went back to my other Win 11 computer (where the app did not work yesterday) and checked printer settings, saved settings and then started the Access app.  The Access app created the PDF as expected.  I have no idea what changed.

 

I then went back to Win 10 computer, opened the APP, and once again the Access app locked up when I tried to create the PDF.  The app has worked on this Win 10 computer for several years with no issues but now no joy.

 

I dont know what to look for on the Win 10 computer.

Re: [MSAccessProfessionals] Report Not Working

Thanks for taking the time to reply.  I dont think the issue is with my Access file but instead is with the OS or computer settings.

 

I was able to verify this by installing the app on a third computer (Win 11) and the app works as it has for the last several years.  I went back to my other Win 11 computer (where the app did not work yesterday) and checked printer settings, saved settings and then started the Access app.  The Access app created the PDF as expected.  I have no idea what changed.

 

I then went back to Win 10 computer, opened the APP, and once again the Access app locked up when I tried to create the PDF.  The app has worked on this Win 10 computer for several years with no issues but now no joy.

 

I dont know what to look for on the Win 10 computer.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116740) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_

Re: [MSAccessProfessionals] Migrate MsAccess Frontend with SQL Server Backend to Azure

I won't address the different Azure options as I don't know them well enough. Others here are much better suited to compare them.

I have a fair amount of experience working with Azure and your biggest wildcard regarding redesign is how your existing app is structured.  In short, you need to minimize the amount of data that moves back and forth between the app and the cloud.  If you've already done that, there may be very little to redesign.  For example, a form that pulls 1,000 records when it loads may work fine with an on premise server but be unusable with data in the cloud.  Complex Access queries may need to be changed to views/stored procedures/functions/pass through queries/etc. When my employer moved to Azure from an on premise server, I had to tweak a few things in the various apps I created/support, but for the most part everything worked fine.

Paul

------ Original Message ------

From: "drnorbert2002 via groups.io" <drnorbert=msn.com@groups.io>

To: MSAccessProfessionals@groups.io

Sent: 1/20/2026 2:28:10 PM

Subject: [MSAccessProfessionals] Migrate MsAccess Frontend with SQL Server Backend to Azure

I am planning to migrate MS Access front end + SQL Server 2022 backend on Server 2022 on-prem to Azure architecture.

Anybody has any experience?

What is the fastest and most cost-effective Azure architecture with minimal redesign?

10 users-

SQL Database 2 Gib

MsAccess program 56 Kb

Azure SQL vs SQL Server VM decisions

Thanks,

Norbert