Access2010 to Sharepoint2010 via ODBC? (1 Viewer)

[bayman]

Can I publish an Access2010 database to Sharepoint2010 with linked tables? Or, am I limited to Access tables only?

Thanks in advance.

 

[Pat Hartman]

I'm not sure what "publishing to" entails but you can use the ODBC link to link to SharePoint tables.

 

[bayman]

I've got Access forms/tables that I want to publish to a Sharepoint server, so users can use my Access app via a web app on the Sharepoint server. In such a scenario, am I prohibited from using linked tables in Access to publish to Sharepoint?

 

[Pat Hartman]

Have you tried it? I'm going to guess that if this is a "web" database, then it cannot link to anything except SharePoint tables. My understanding is that you can create a standard client/server app and link that to what ever you want including SharePoint, SQL Server, Oracle, ACE, all at the same time. But, you will distribute the FE as you would any FE. It doesn't run under the control of SharePoint and it isn't published.