I was given the task of writing a project management database. This database will be used in two separate facilities separated by about 75 miles. The database will be used to keep track of upcoming projects. Management in both places need real-time up to-date project status information.
How is the best way to do this? I have Access 2010 and have been looking at the SharePoint stuff. This will be a runtime application. Does one copy of SharePoint cover everyone? What about security? This will be future products for my company so this information has got to be secure. I was wondering if anyone has had a chance to build any applications with this and could share some ideas.
One of the ideas that was kicked around was keeping everything up to-date via e-mail. Any ideas on using e-mail or using Microsoft SharePoint would be gratefully appreciated.
Thanks in Advance,
K. Smith