database - Hosting an Access DB

Question

So I'm inexperienced in hosting DB's and I've always had the luxury of someone else getting the db setup.

I was going to help a friend out with getting a webpage setup, I've got experience in Asp.Net MVC so I'm going with that. They want to setup a search page to query a db and display the results. My question I have is in getting the DB setup and hosted. They currently just have the Access DB on a local computer. There is basically only one table that would need to be queried for the search.

What is the best approach to getting this table/db accessible? They would like to keep the main copy of the db on the local machine, so copying the entire db over to the hosted site would be time consuming, could the lone table needed be solely copied to the host? Should I try to convince them to make changes on the hosted db and just make copies of that for their local machines? Any suggestions are welcome, Again I'm a total noob when it comes to hosting databases.

Thanks

Added: They are using a MS Access 2000, and the page will have access restrictions. Thanks for the responses.

Answer 1

How about SQL Server Express? I think you can do a remote connect from Access and just push the data over from Access.

I wouldn't use Access on a web server in any case.