I've created an Access 2007 application that has linked tables in a SharePoint 2007 site. Normally, after I open the app and access a form that uses one of these linked tables, you are prompted for a user name and password by SharePoint, which works fine. But sometimes, it won't automatically prompt you for a username and password, instead it will say there is a Network/IO error.
What I am trying to do is make the application prompt you immediately for that username and password as soon as you open the table. That way there will be no errors. First I added a RefreshLink to the vba code in the on_load event for the main form. It works, but for those people with dial-up connections, it was incredibly slow. Is there any other way in vba to prompt the sharePoint site to ask for the login info?
What I am trying to do is make the application prompt you immediately for that username and password as soon as you open the table. That way there will be no errors. First I added a RefreshLink to the vba code in the on_load event for the main form. It works, but for those people with dial-up connections, it was incredibly slow. Is there any other way in vba to prompt the sharePoint site to ask for the login info?