托管Access数据库 [英] Hosting an Access DB

问题描述

我会帮助一个朋友，因为我没有经历过数据库的安装。有了网页设置，我有Asp.Net MVC的经验，所以我要去。他们想要设置一个搜索页面来查询数据库并显示结果。我的问题，我有在获取数据库设置和托管。他们当前只在本地计算机上具有Access DB。基本上只有一个表需要查询以进行搜索。

获取此表/数据库的最佳方法是什么？他们希望在本地机器上保留数据库的主副本，因此将整个数据库复制到托管站点将是耗时的，可以将孤立表仅复制到主机吗？我应该尝试说服他们对托管的数据库进行更改，只是为其本地计算机的副本？欢迎任何建议，再次，我是一个总的noob当涉及托管数据库。

感谢

已添加：他们正在使用MS Access 2000，该网页将具有访问限制。感谢您的回复。

解决方案

SQL Server Express如何？我想你可以从Access远程连接，只是从Access推送数据。

我不会在任何情况下使用Web服务器上的Access。 p>

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.

解决方案

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.

这篇关于托管Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！