Jumat, 17 Mei 2013

[MS_AccessPros] Re: Using Access Database and Sharepoint

 

Hi Chris,

There are two ways of storing data in Access tables in SharePoint.

1) A "Hybrid" Database
This is an Access 2010 or 2013 desktop database where the Access tables are migrated to SharePoint Relational Lists. Not just SharePoint Lists but Relational Lists which ensures data integrity. See this excellent video for how to set up and migrate your tables to SharePoint Lists.
http://www.youtube.com/watch?v=3wdjYIby_b0&list=UUvoZM0Ek7xJNlH1l4ZoX1kA&index=1

2) An Access 2013 Web App
This requires
A.) An Office 365 account that includes SharePoint
Or
B.) The company has its own SharePoint 2013 and SQL Server 2012 licenses.

With the Web App you can import your Access Tables but the rest of the Web App you will have to build from scratch.

I recommend the Hybrid App because it is far easier to do and you can keep your desktop databases with VBA. The users can work offline and then Access automatically updates the SharePoint Lists for you.

Kind Regards,
Patrick Wood
Gaining Access Technologies Founder
http://gainingaccess.net
Microsoft Access and SQL Azure Information Center for Developers
http://gainingaccess.net/SQLAzure/AccessAndSQLAzureInfo.aspx

--- In MS_Access_Professionals@yahoogroups.com, "cjschuel" <cjschuel@...> wrote:
>
> I have a client that has been using an Access Database for years. Now the company has Sharepoint and wants to put the database in Sharepoint. Since Sharepoint is not a relational database, I was trying to figure out what my options are for using an Access database with Sharepoint. Any thoughts are greatly appreciated.
>
> Chris
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar