we have developed a SQL database which we use to track and maintain information about individual tasks we perform on projects.
We have developed front-end forms in MS Access to create and query task records from the SQL database. We use this database locally here in my office and it works quite well.
We would like to emulate the MS Access forms in SharePoint and use that as a front-end instead of using the forms that we have developed MS Access.
I would like to know the best way to go about this and which approach might be the best way to proceed. We would need to have read/write access to the SQL database. I understand that the Business Data Catalog would be one approach but I’m not sure if this the best approach given what we are trying to achieve. If this is the best approach, given we do not have programming skills, would we be able to implement this ourselves. Would the Collaborate Team offer services to construct a front-end?
Also, if there are tools already developed that would suit our needs, I would not want to reinvent the wheel on this.
Thanks for your time.