Hi Folks,



In attempting to convert a database for non-profit local government that is currently using ODBC connection to use SharePoint instead, I am reaching a stumbling block. If I sign into SharePoint the database opens and works fine; however, in testing if I attempt to open the same database in the run-time version of Microsoft Access, it not only doesn't run properly but it never prompts me for the credentials needed to access the linked tables. Is there a way that I can prompt the user for their Microsoft Office 365 credentials at the open of the database file, in this way the tables will be able to load? I am surprised that MS Access doesn't automatically recognize that the tables are via linked SharePoint and that it automatically generates either an error saying such or better yet prompts the user that what they are trying to access requires them to be logged into Microsoft Office 365 ... instead, the database just hangs. Any help would be greatly appreciated.

Thank you,

Joe