How connect Access front-end to Sharepoint backend

[SteveL]

I have successfully migrated a simple Access backend table to my SharePoint site. But I cannot figure out how to link the table in SharePoint to my Access front-end. Can anyone help?

--Steve

 

[GohDiamond]

What Version of Access are you running?

In Versions 2007 and forward got to External Data Tab, Import & Link, More...
When you select the More dropdown menu you should see Import or link a SharePoint List. Then there will be dialog boxes that popup and ask for the SharePoint site URL, etc. as you would expect from a File Select dialog...

Hope this helps,
Cheers!
Goh

 

[SteveL]

Access 2013. I have tried what you suggest and I enter the server name but it doesn't work. I have the table (just one table) on my SharePoint server but I cannot get the front-end file to link to it.

 

[supmktg]

Not sure if you've solved this yet?
If you created the table using an Access Web App:

1) Open the Web App
2) Click File
3) In Info View, click Manage Connections.
You will need to Allow connections from My location or Any location.
You will need to Enable Read-Write or Read only connection.
You can then View the connection information that includes the server name, the database name, the user name and the password for an ODBC connection to the database.

I had trouble making my connection selections stick. I discovered that it takes a little while (more than a few minutes in my case) for the connection settings to be applied.

HTH,
Sup