Jumat, 08 Oktober 2021

[MSAccessProfessionals] Refreshing SharePoint lists with Access 2016

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