Access Database stored on Sharepoint

[Mark44stfc]

Hi All,

I am currently looking to share an access database with colleagues in a different location that access different servers and so cannot store the database locally due to speed issues from elsewhere.

I now want to run a Query into an Excel file from the database but struggling to find how to access the DB on the SharePoint.....


Anyone have any experience with this? I am assuming it to be quite a simple task

 

[gmhumphr]

This article was a great resource for me when I was trying to write events from Excel to an Access Database. Perhaps it can give you the high level you need about the connection to make it work for you (and with SharePoint).

http://www.datawright.com.au/excel_resources/excel_access_and_ado.htm

 

[Mark44stfc]

Thanks, I have managed to figure it out with a few different articles including the one above