Need information on how to migrate Access 2007 DB to SharePoint.
Existing Setup:
~Complex Access 2007 database (been evolving for 15 years)
~Accde file renamed to Accdr provided via network share for users to access
~Clients all use the runtime version of access
~All Access tables are DSNLess links back to SQL Server 2008 DB
~All Queries, Forms, Reports, Modules all in Access
The Need for Change:
~The "business" is moving towards Sharepoint for most everything and wants to know if it is possible to migrate this Access database. The them for this trend is "One Face for the Company". I have done some preliminary research on the subject and see there are some ways to migrate tables from Access but I am unable to find anything that describes how to handle the scenario above.
Also, I am unsure of how the forms and reports are displayed in/via Sharepoint. Do they pull up using the runtime of Access in the background? Do reports and complex forms with multiple subforms work the same? Do modules continue to function? Any information or sources of information on how to fully migrate this Access database to Sharepoint is appreciated.
Existing Setup:
~Complex Access 2007 database (been evolving for 15 years)
~Accde file renamed to Accdr provided via network share for users to access
~Clients all use the runtime version of access
~All Access tables are DSNLess links back to SQL Server 2008 DB
~All Queries, Forms, Reports, Modules all in Access
The Need for Change:
~The "business" is moving towards Sharepoint for most everything and wants to know if it is possible to migrate this Access database. The them for this trend is "One Face for the Company". I have done some preliminary research on the subject and see there are some ways to migrate tables from Access but I am unable to find anything that describes how to handle the scenario above.
Also, I am unsure of how the forms and reports are displayed in/via Sharepoint. Do they pull up using the runtime of Access in the background? Do reports and complex forms with multiple subforms work the same? Do modules continue to function? Any information or sources of information on how to fully migrate this Access database to Sharepoint is appreciated.