I have a client (Non-Profit Org) with an Access 2003 app as a front end to a SQL 2000 database using ODBC connectivity. Multiple users access the SQL db using the Access 2003 db front end app from XP workstations running Access 2007.
My ultimate goal is to get the clients SQL database upgraded to SQL 2008, and then upgrade/move/export/migrate the Access 2003 front end app to SharePoint.
I have read many articles and posts, but no two agree on the process to migrate to SharePoint. Most recommend the SQL 2000 to SQL 2008 migration as the first step, but they diverge from there. (I have migrated/exported the SQL 2000 db to SQL 2008, on another server, and tested the Access 2003 front end app without any apparent problems.) Some, recommend upgrading the Access 2000 app to Access 2007 (MDB to ACCDB) without changes to the MDB. And, some have recommended changing the Forms and Reports to Web pages before migrating the MDB to ACCDB. Then many recommed moving the ACCDB to SharePoint.
Any suggestions as to what would be the correct process for acheiving my goal as quickly, and painlessly, as possible?
Thank you,
PCnetMD
My ultimate goal is to get the clients SQL database upgraded to SQL 2008, and then upgrade/move/export/migrate the Access 2003 front end app to SharePoint.
I have read many articles and posts, but no two agree on the process to migrate to SharePoint. Most recommend the SQL 2000 to SQL 2008 migration as the first step, but they diverge from there. (I have migrated/exported the SQL 2000 db to SQL 2008, on another server, and tested the Access 2003 front end app without any apparent problems.) Some, recommend upgrading the Access 2000 app to Access 2007 (MDB to ACCDB) without changes to the MDB. And, some have recommended changing the Forms and Reports to Web pages before migrating the MDB to ACCDB. Then many recommed moving the ACCDB to SharePoint.
Any suggestions as to what would be the correct process for acheiving my goal as quickly, and painlessly, as possible?
Thank you,
PCnetMD