Results 1 to 4 of 4
  1. #1
    JustAnElf is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2013

    Login screens with SharePoint

    On my MS Access/SharePoint hybrid application I have noticed the Access database will hang if I open Access and go directly to a query. It never asks for a user name and password to read the lists located on the SharePoint server.

    To get around this I select the refresh list option on one of the tables prior to accessing a query, report, or form for the first time. This will cause MS Access to display the login screen to SharePoint and establish the proper links.

    How do I setup the MS Access database so it asks for the user name and password as soon as the user opens the MS Access database? This would prevent my database from hanging.

  2. #2
    adawg is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Feb 2014
    Not sure if you're still looking for the answer here or not. If you use a macro to enable one of you sharepoint tables and then automatically close it, the login screen will show up when you start the database.

    Click image for larger version. 

Name:	Office365 Login - Auto Startup.png 
Views:	20 
Size:	12.6 KB 
ID:	15397

  3. #3
    JustAnElf is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2013
    Hi adawg,

    Your macro idea looks sound. What I eventually discovered is that the Internet Explorer security settings were set too high. After I lowered them the problem went away. My solution works great if your company allows this. If not, then your solution by far would be the way to go.

  4. #4
    MiaGrace is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Mar 2014
    I can't comment on CRM Software, but Gmail can be used with any mail client like Outlook. You are never required to access Gmail through a browser. I've always accessed Gmail through Outlook and now the mail client that ships with OSX. Do you have any idea about this

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Print screens or something better
    By crowegreg in forum Database Design
    Replies: 2
    Last Post: 09-17-2013, 12:11 PM
  2. Refresh SharePoint List - SharePoint 2010
    By jgelpi16 in forum Programming
    Replies: 0
    Last Post: 08-22-2013, 06:21 AM
  3. Is Sharepoint right for us?
    By kpo in forum SharePoint
    Replies: 2
    Last Post: 10-18-2012, 02:33 PM
  4. Sharepoint List Query Filter based upon User Login
    By Steven.Allman in forum SharePoint
    Replies: 5
    Last Post: 03-22-2012, 11:30 AM
  5. Login form with nt login
    By hitesh_asrani_j in forum Forms
    Replies: 6
    Last Post: 09-22-2011, 11:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums