Do you know of a way to programmatically force SharePoint lists to refresh/update? I have multiple users of an Access 2016 database where the tables are stored and shared as SharePoint lists. Lately, following a major SP update at the Company, I have been encountering issues where two users will get different record counts from the same lists. Also, updated fields will appear missing on another users system.
Just wondering if there are any solutions to this situation.
Thank you
Dean Waring
Sent from Mail for Windows
From: Bill Mosca
Sent: Thursday, October 7, 2021 10:58 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Binary Data in Forms and Reports
Hi Norbert
You shouldn't be deleting the binary code in Access objects. It is needed to make the objects work. Deleting the wrong stuff could break your objects. Exporting into a new, blank database will remove all the unnecessary code such as the blocks for deleted controls.
The ExportAll add-in is in https://groups.io/g/MSAccessProfessionals/files/0_Utilities%20and%20Add-ins Be sure to read the ReadMe file so you extract the add-in to the right folder. Add-ins have pre-determined folder paths in their tables.
Regards,
Bill Mosca
From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of drnorbert@gmail.com
Sent: Thursday, October 7, 2021 6:26 AM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Binary Data in Forms and Reports
Thanks, Bill, for the great explanation.
Are you aware of how the creation of unnecessary binary data can be eliminated?
You are correct when I export the form or report and delete the Binary Data and import again remain it shrinks, however when I make a change and repeat the export process the Binary Data is recreated.
I always keep watching the bloating of the program as well.
Can you share please Is your ExportAll utility?
Regards,
Norbert
Tidak ada komentar:
Posting Komentar