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.