I have two people who want to use the database I created, which means 2 connections from remote locations. Can this be done?
我有两个人想要使用我创建的数据库,这意味着来自远程位置的2个连接。可以这样做吗?
I've recently come across an article citing numerous problems with using MySQL as a back end for Access, would I be better off just building an access database, and if so, could I still host it online for 2 people to use?
我最近遇到一篇文章,指出使用MySQL作为Access的后端存在很多问题,我最好只建立一个访问数据库,如果是这样,我还可以在线托管它供2人使用吗?
1 个解决方案
#1
0
I suspect that the configuration you have in mind is:
我怀疑你想到的配置是:
-
put your MySQL database on a server that allows direct connections to MySQL from the Internet,
将您的MySQL数据库放在允许从Internet直接连接到MySQL的服务器上,
-
define a MySQL ODBC DSN for that database on each of the two remote machines, and
在两台远程计算机上的每台计算机上为该数据库定义一个MySQL ODBC DSN
-
install an Access front-end with ODBC linked tables to access the MySQL database over the Internet.
安装带有ODBC链接表的Access前端,以通过Internet访问MySQL数据库。
If so, then you can do that, but you probably don't want to. The Access front-end will "talk" to the linked tables as if they were on a local LAN connection, and depending on the complexity of the Access application and the speed of the Internet connection between the clients and the MySQL server the results could range from "a bit sluggish, but usable" to "so slow as to be unusable".
如果是这样,那么你可以这样做,但你可能不想这样做。 Access前端将与链接表“对话”,就好像它们位于本地LAN连接上一样,并且根据Access应用程序的复杂性和客户端与MySQL服务器之间的Internet连接速度,结果可能会有所不同从“有点迟钝,但可用”到“慢到无法使用”。
With recent versions of Access the "recommended" way to share an Access database over the Internet would be to convert the database tables to SharePoint and then create an Access "web database". However, that would be a lot of work for just two users.
使用最新版本的Access,通过Internet共享Access数据库的“推荐”方法是将数据库表转换为SharePoint,然后创建Access“Web数据库”。但是,对于两个用户来说,这将是很多工作。
One other option would be some sort of remote desktop solution like Terminal Services, but again that could turn out to be fairly expensive (in time and money) for just two users.
另一个选择是某种远程桌面解决方案,如终端服务,但对于两个用户而言,这可能会相当昂贵(时间和金钱)。
#1
0
I suspect that the configuration you have in mind is:
我怀疑你想到的配置是:
-
put your MySQL database on a server that allows direct connections to MySQL from the Internet,
将您的MySQL数据库放在允许从Internet直接连接到MySQL的服务器上,
-
define a MySQL ODBC DSN for that database on each of the two remote machines, and
在两台远程计算机上的每台计算机上为该数据库定义一个MySQL ODBC DSN
-
install an Access front-end with ODBC linked tables to access the MySQL database over the Internet.
安装带有ODBC链接表的Access前端,以通过Internet访问MySQL数据库。
If so, then you can do that, but you probably don't want to. The Access front-end will "talk" to the linked tables as if they were on a local LAN connection, and depending on the complexity of the Access application and the speed of the Internet connection between the clients and the MySQL server the results could range from "a bit sluggish, but usable" to "so slow as to be unusable".
如果是这样,那么你可以这样做,但你可能不想这样做。 Access前端将与链接表“对话”,就好像它们位于本地LAN连接上一样,并且根据Access应用程序的复杂性和客户端与MySQL服务器之间的Internet连接速度,结果可能会有所不同从“有点迟钝,但可用”到“慢到无法使用”。
With recent versions of Access the "recommended" way to share an Access database over the Internet would be to convert the database tables to SharePoint and then create an Access "web database". However, that would be a lot of work for just two users.
使用最新版本的Access,通过Internet共享Access数据库的“推荐”方法是将数据库表转换为SharePoint,然后创建Access“Web数据库”。但是,对于两个用户来说,这将是很多工作。
One other option would be some sort of remote desktop solution like Terminal Services, but again that could turn out to be fairly expensive (in time and money) for just two users.
另一个选择是某种远程桌面解决方案,如终端服务,但对于两个用户而言,这可能会相当昂贵(时间和金钱)。