We have an Access 2007 database that we want to "integrate" with SharePoint. I know very little about SharePoint but our SharePoint administrator has been describing how SharePoint can work with our Access database (a SharePoint server was installed about 6 months ago).
To make a long story short, I only heard what we could do with SharePoint and after months of talking about it, our administrator/SharePoint guy was unable to get much of SharePoint to work with our Access database. So now I have an Access database that was programmed around what he described and is pretty much complete but the interaction between Access and SharePoint is still a mystery to me because I haven't seen any of it.
So my question is
- All the tables, forms, queries, and reports have already been coded in Access 2007. How complicated is it to use SharePoint as the entry and exit doors to the Access database to keep track of the workflow tasks and when each assigned person has completed their updates in the Access database?
Our workflow is as follows:
Configuration Manager -> Engineering Lead -> Tool Designer -> 6 departments in parallel for labor estimates
Once all 6 departments have completed their department's labor estimate then the engineering lead and program manager are notified of the finished estimate.
I've also heard the database can be imported into SharePoint as Lists and EVERYTHING could be done through SharePoint. Depending on the development/programming time for SharePoint development, I don't want to duplicate the development time that has already been invested in Access unless there is an overwhelming reason to do so.
We received an estimate from a consulting firm to do the SharePoint programming and they came back with an estimate of over 200 hours. For 200 hours, it seems like it could be completely re-written in SharePoint. Is it more complicated to use SharePoint with Access than it is to just use SharePoint?
Your recommendations are greatly appreciated.