Search results

I will see what I can do. The application is a front-end to SharePoint Online and so credentials would be needed. Perhaps I can copy relevant tables data into a local test database to demonstrate the issue.

Thanks for your interest, Pat. Yes, I have used aliases in my query.

I recently ran into an issue that seems to be an unintended side effect of the Monaco SQL editor. In the latest version of Access I am using (MSO Version 2506 Build 16.0.18925.20076 64-bit), the Monaco editor has been enhanced to offer quite a lot of new functionality. One of these enhancements...

No question that a server DBMS is more robust and more scalable, but companies have been running production applications on LAN-based products for literally decades. With the right network infrastructure, appropriately scaled projects, and proper backups, there is no reason you should...

It is so easy to cast stones...

I think there may be some confusion over what you mean by data in SharePoint and your use of the term "tables". At first I assumed you were talking about SharePoint list data. Access can directly import from or create links to lists in SharePoint Online But from the above statement, it sounds...

Yes, this makes more sense.

I'm late to this thread, but what we have done successfully is to use good old Microsoft Word mail merge using Outlook. We export the source list from Access, link the Word merge template to it, and go. This avoids any complex VBA coding or use of OLE automation. This does require Outlook...

Splitting a database is mostly for multi-user deployments. Having a shared back-end database with front-end logic deployed to workstations improves performance and scalability.

FWIW, I have encountered failures making .ACCDE files on my Arm-based Surface Laptop 7 with Access running under emulation, while there are no issues with the same file on an X86 device. (Everything else is fine; I use Access on this device daily.) I mention it just in case he might be running...

The accdb file you modify should be the one you saved after you split the database originally (i.e., the front-end application). If you did not do this, then yes, you would need to split the database again and discard the back-end file. But this time, save your front-end accdb file so that you...