(如何)终端服务/远程桌面可以用来共享Access数据库吗?

发布于 2024-07-25 17:13:02 字数 294 浏览 11 评论 0原文

我以前使用过的唯一类型的“远程桌面”应用程序是 VNC 查看器。 我对这种应用的理解是,当多个用户登录同一个VNC服务器时,他们共享键盘、鼠标和桌面,因此只有一个人可以实际使用计算机,而其他用户可以观看正在发生的事情。 这显然有它自己的用途。

我想要做的是在远程服务器上提供 MS Access 应用程序。 我希望 2 或 3 个用户能够同时登录到此应用程序,所有用户都在共享数据源上工作。

这可能吗? 不幸的是,我的 Google-fu 今天很弱。 我想要的是终端服务吗? 远程桌面连接? 还有别的事吗?

The only type of 'remote desktop' application I've used previously is VNC viewer. My understanding of this kind of application is that when multiple users log in to the same VNC server, they share the keyboard, mouse and desktop, so only one person can actually use the computer, whilst the other users can watch what is happening. This obviously has its own uses.

What I want to do is have an MS Access application available on a remote server. I want 2 or 3 users to be able to simultaneously log in to this application, all working on a shared data source.

Is this possible? My Google-fu is unfortunately weak today. Is it Terminal Services I want? Remote Desktop Connection? Something else?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

追风人 2024-08-01 17:13:02

“远程桌面”(终端服务/MSTSC)确实为每个用户提供单独的桌面 - 与共享的“远程协助”相反。 但是,我不得不说,这不一定是提供对数据库的访问的最佳方式 - 除了多人访问数据库之外,您还要让服务器提供 [n] 个用户会话。

对于数据库应用程序,需要考虑的选项:

  • 在中央文件服务器上托管数据库文件(在访问的情况下); 计算机上使用该应用程序
  • 每个客户端在拥有适当数据库服务器的 ; 不是势利,而是 Access 的扩展性不太好; SQL Server Express Edition 是免费的...该应用程序可以作为标准 exe 在每个用户的(本地)桌面上运行,
  • 并将该应用程序作为由该/另一台服务器托管的 Web 应用程序; 那么您就只有一个瘦 Web 服务器应用程序,为每个用户的浏览器提供内容(而不是每个用户的完整会话)

"Remote Desktop" (terminal services / MSTSC) does have separate desktops per user - contrast to "Remote Assistance" which shares. However, I have to say that is not necessarily the best way to provide access to the database - you're making the server provide [n] user sessions in addition to the multiple people accessing the database.

For a database app, options to consider:

  • hosting the database file (in the case of access) on a central file server; each client uses the app on their machine
  • having a proper database server; not snobbery, but simply that Access doesn't scale very well; SQL Server Express Edition is free... the app might run as a standard exe on each user's (local) desktop
  • have the app as a web application hosted by the/another server; then you just have a thin web-server application serving content (rather than a full session per user) to each user's browser
蓝眼泪 2024-08-01 17:13:02

这篇文章可能会有所帮助。 我也很确定它可以与终端服务器/远程桌面配合使用,但您需要在 共享模式

This article might help. I am also pretty sure it will work with Terminal Server/Remote Desktop, but you need to set your Access app in Shared Mode

苏佲洛 2024-08-01 17:13:02

我目前正在使用 Windows 2003 Server 和终端服务服务器,并拥有 35 个用户的许可证。 我有两个用户共享的访问数据库,并且已经这样做了近一年了。 效果很好! 坚固可靠。 Access 数据库都是分离的(前端与后端分离)。 远程用户遍布美国东南部。 完美的表现。

本·斯文宁

I currently am using Windows 2003 Server with Terminal Services Server with licenses for 35 users. I have two access databases that the users share and have been doing so for almost a year now. It works great! solid and reliable. Access databases are both split (front-end is separate from back-end). Remote users are throughout the Southeastern United States. Excellent performance.

Ben Swenning

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文