By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,932 Members | 1,687 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,932 IT Pros & Developers. It's quick & easy.

Migrating Access/SQL DB to Sharepoint

P: 1
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.
Mar 3 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.