Recent content by KACJR

For testing purposes, I created C:\AccessDatabases, copied the front-ends to this folder. Unblocked the FEs, then made shortcuts of all of the FEs to my Desktop. One thing I noticed immediately is the FEs are launching quicker and processing quicker.

So I should put the FE in a non-QneDrive folder and put a shortcut on the Desktop.

Azure SQL

And does this work if the FE location is on my OneDrive?

What is the Date value?

Greetings, my friends... Most staff at our remote sites have Microsoft 365 Business Basic licenses (because they're free for non-profits). As you know, this means that users have access to the web-based Office apps only. We updated our Access Runtime 2016 to Access Runtime for Microsoft365 in...

The Boolians are flags that identify which programs an individual is a member of. They are here for reporting purposes only.

I tried just as you suggested and wound up getting the same error.

I come again to the well of knowledge... Access 2016, Azure SQL instance. My application maintains a local table of "AllClients" which is a subset of my AllPeople table. At app startup, the sub that drops AllClients then creates a new AllClients table works fine. Then, later on, the same sub...

After reading the posts here as well as in other forums it seems that Stored Procedures is the way to go. Our database consultant also agrees that Stored Procedures will resolve most performance issues. So that's the direction I'm gonig to take.

Yes, every table has a PK and each record timestamp.

Looks like I may have to bone up on stored procedures, then.

Understood, pulling this together now. Also, understand that this code works sometimes and sometimes not.

Yes. Data is massaged. Several queries do inner joins to pull in data from multiple tables.

I come again to the Well of Knowledge... Just a question, actually. Since moving our SQL backup from an on-prem SQL Server to Azure SQL, the performance of our Access front-ends has slowed dramatically. We were warned and expected this to be an issue. However, I was not expecting VBA...