I have an Access database that is set up to sync with a SharePoint list. Just recently, whenever I open the Access DB, I am prompted to login with my SharePoint username and password. Is there a setting I can change so I don't have to login everytime I open Access? I only want to login when I need to refresh the linked table.

Hi,

(IMG:style_emoticons/default/welcome2UA.gif)

Are you working "Offline?"

No, I am working "Online with SharePoint". Would it create any problems if I set it to work "Offline" and then just changed it to "Online" when I wanted to synch the database to the SharePoint list?

I see. That's why you were being asked for your credentials. If you work "offline," you won't be asked for your username and password. If you don't want to work "online" and just want to update the data with SharePoint, you can just use "Synchronize."

Hope that helps...

Also, this is vague and may be not entirely correct but to "remember the credentials", you need to configure the Internet Explorer, specifically, add the sharepoint's URL to "local intranet" zones. You should be then able to use the "Remember me?" checkbox and won't be asked to log in again afterwards.

Try this. Go to your SharePoint site in your browser. From the browsers tools menu, go to security and add the site to either your "intranet" or "trusted" sites.
Intanet site addition: This will not prompt for SharePoint credentials. Trusted sites addition: This will prompt for SharePoint credentials once.