ACCESS FEED: Januari 2026

Rabu, 21 Januari 2026

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.

_._,_._,_

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

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.

_._,_._,_

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 dont know what to look for on the Win 10 computer.

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

Selasa, 20 Januari 2026

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

Re: [MSAccessProfessionals] Report Not Working

Hi David,

If I had to debug this, I would start with the query for the report. Design the report and check the RecordSource property. Run the query. Same issue?

I would also change the query to return just a few records … where CustomerID < 5, so the report would only be a few pages. Does that work OK?
Also inspect the VBA code (if any) in the report's code-behind. As a test you can comment out everything.

-Tom.

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

I sent this earlier but it is not showing up in my groups messages, so I apologize if this is a duplicate.

I have an Access 365 application that I created several years ago (I am not a professional) with a FE and a BE. One of the modules produces a PDF report after I enter a lot of data. It has worked for years now and then suddenly it does not. Instead of outputting the report it spins with a message at the bottom of the screen saying "formatting page". That message never stops and ultimately the OS will report that Access is not responding.

I do not know how to proceed with trouble shooting this and would appreciate any help.

[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

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_