Microsoft Access Logo
This post will be a short one! The reason for that is because I’m just going to mention a solution a coworker is working on at the moment. He hasn’t ironed out all of the kinks yet. We’ve been dealing with the issue of users using MS Access databases. Unfortunately in the newer version of Access 2007, Microsoft has removed the ability to split your databases and merge them later. People would split the databases so that they could have multiple people entering data and then merge them later.
This same functionality can be achieved through SharePoint. However, you still have to “Publish” to SharePoint so it’s not in real time. Today he showed me how to link a database to a SharePoint site so that changes to the Access database are replicated in real time in SharePoint and vice versa. This means that we will be able to maintain the integrity of an Access database, but allowing users to make real time modifications either through SharePoint or Access. We still have a lot of testing to do – but this definitely looks exciting! I’ll post again when we’ve ironed out the entire process.
