Access to SharePoint

[Wil Peek]

Last week our SharePoint environment moved to a new server with a different URL. We use Access to connect to the database on SharePoint to make mutations on the database. I now have to convert the links in Access to the databases on the new environment.

When a select the link to the database in Access and select “Relink” a can select the correct database on the left but can’t find the file on the right. I thought I should choose a file type there, but the correct type is not included. Can anybody help me?

 

[Jon]

Welcome to the forums!

To help us better understand your needs, I would be very grateful if you could complete this 2 minute survey: Click here for the survey

All surveys are anonymous and not linked to your account.

I want to keep this the very best place for Access and your feedback helps us!

 

[theDBguy]

Hi. Welcome to AWF!

Can you post some screenshots?

 

[Isaac]

@Wil Peek
I was going to suggest bringing up the more-robust Linked Table Manager, rather than the "Relink" option that is seen on linked SP lists.
Does that bring up a more full-featured dialogue box with better options?

This is what mine looks like: