Search results

I went back and repeated the process of putting the FE into a folder not managed by OneDrive. I then added the suggested registry settings. Tried again and it worked. What threw me was I created a shortcut on the desktop pointing to the FE in the Trusted Location, but also resulted in the...

I appreciate all of your suggestions; they all make sense. I installed Access Runtime for Microsoft 365. I created a folder on the C: drive not managed by OneDrive. I copied the front-ends to this folder. I added the appropriate settings into the Registry as noted above. Rebooted the PC. Tried...

This is what we asre doing. Everyone gets their own copy of the front-end. All of our individuals OneDrives are privately "owned".

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...

I will try that first. My SQL knowedge is rudimentary. But this query did the trick. I now have a correct count for CONWAY. So thank you!