SharePoint

[zezo2021]

I connect Access to the SharePoint list

the first time connected and work

after that takes a long time to connect and access stop work and hang

What should I do to connect to SharePoint


How could I open the email login screen log in to the user when the application starts or after the application start?



=====================

Say

Calculating and never connect

 

[GPGeorge]

While that seems to be a serious problem, it's not one anyone can diagnose from outside your environment. It could be network congestion, for example. It could be, heaven forbid, you are using a slow, intermittently unstable WiFi connection. It could be local activity on your own computer. I run back up software, for example, when it starts, all other processes slow down. I set it up, therefore, only to run over night, not during working hours.

Other possibilities could be large recordsets being retrieved when the accdb starts. It could be local caching of the SharePoint data going on at startup. It could be inefficient or inappropriate indexes on tables queried at startup.

The last question is not clear to me. What email login screen are you interested in?

 

[zezo2021]

when I press refresh on the list or linked table

this box appear

 

[GPGeorge]

when I press refresh on the list or linked table

this box appear

I see. That means the credentials for the Linked SharePoint list are probably not being cached. For SharePoint, that might be different from other linked tables, so let me do a quick refresher for myself. It's been a long time and I don't recall ever seeing that message.

Also, it could be that Access is churning away trying to establish the initial connection at startup, and failing. That would account for the delay you report.

 

[GPGeorge]

I don't see that problem. (Famous trouble-shooting words, I know.)

What I do suspect is that the linked SP lists in your accdb are not storing the SharePoint credentials needed to reconnect at start up. That would account for the delay in starting and the message you showed.

Try relinking the tables again, starting from scratch, maybe delete one linked SP list and relink it again. Make sure the MS 365 account you use to connect is one that you can always connect to otherwise.

 

[zezo2021]

Thank you
How can I delete the old SharePoint link?

 

[zezo2021]

this message appears when reconnecting in office 2016



the application runs very good with office 2019