By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,652 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,652 IT Pros & Developers. It's quick & easy.

Access 2007 SharePoint Login Doesn't Always Work

P: 3
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?
Jul 12 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.