Migrating an Access Database to a Windows SharePoint Services Site
You’ll learn in Part 7 of this book that you can use an SQL server as a data source for an Access project file. You can also use a Windows SharePoint Services site as a data source for your Access 2007 database. You can either publish or move your Access 2007 database when migrating to a SharePoint site. When you publish your database, you are simply copying your database to the Windows SharePoint server so that others can open and use it. Any changes you make to the data in the local copy are not reflected in the copy on the SharePoint site. If you change queries, forms, reports, macros, or modules, you must republish your database to make the copy on the server current.
When you ...
Get Microsoft Office® Access 2007 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
