What's the best setup for hosting data tables remotely and a DB app locally?
Posted on 2011-02-28
Hey all. Looking for some advice on how to handle a situation. I oversee collecting payroll information from about 30 field offices around the state. We're grant funded, so we have all kinds of crazy grant requirements regarding the level of detail we have to keep on where people are charging their time.
I've built an Access 2007 database which does the job beautifully. Now, I need to figure out how to distribute it to everyone. I'm envisioning a system where the data tables are hosted on a web server, and the rest of the app (forms, queries, etc.) is installed on each user's computer. I don't want them to have a separate login for the remote server, if possible. I'd like the app to run seamlessly, as if all of the data were right there on the local computer as well.
I've played around a bit with SharePoint, but I don't think that's going to work. It asks for a SharePoint site login every time I access a table in the database for the first time. I work with a lot of barely computer literate people, so simplicity is a must.
Would it be better to host the tables on a SQL server, or even to redesign the whole app so that all of the forms are Access Web Forms, and host the entire thing online? Any suggestions on how to get this thing up and running will be much appreciated. Thanks!