可以通过终端服务使用多用户Access数据库吗？ [英] Can a multi user Access db be used via Terminal Services?

问题描述

假设我有一台运行终端服务的Windows 2000服务器上有一个单独的

文件Access DB（不是前端/后端），可以多个用户访问

数据库同时存在？

Paul

解决方案

Paul H写道：

说我有运行终端服务的Windows 2000服务器上有单个文件Access DB（不是前端/后端），多个用户可以同时访问数据库吗？

Paul

如果不涉及终端服务，他们可以完全这样做。

意味着它可以完成，但它不会建议除非他们的应用

分开，每个用户获得前端的单独副本。


-

我请勿查看此邮件附带的电子邮件帐户

。发送给... ...

在Hunter dot com的RBrandt

多个用户所在的数据库是什么，但没有使用

相同的对象？


我们从IT团队获得的当前反差之一是

MS特别说Access从

内存池中抽取太多资源。

这有几个答案....主要是如何编程

访问程序，以及在Access数据库中使用了什么技术。


一般来说，大多数IT人员用来监控内存使用情况的实用程序并不是_accurately_反映Access使用_very_

低优先级内存线程对于任何需要更多内存的进程，Access很乐意放弃

。换句话说，

报告工具报告的信息不完整。 （100％使用率！

男人，Access是一头猪！他们没看到的是这个用法的优先级

如此之低移动鼠标导致Access释放

那个内存。）


但是上面说的还有编程方法可以

确实真的生猪一个系统。例如，打开和关闭一个表格一堆

次，或者没有将对象设置为空，并假设在你之后Access会清理

，确实可以有一个重要的

排放系统资源。


知识库中有很多文章可以解决这个问题。可能变得相当复杂。


2005年9月28日13:43:26 -0700，ac ******* @ railvan.com

< ac ******* @ railvan.com>写道：

我们从IT团队获得的当前反驳之一是，MS特别指出Access从内存池中吸取了太多资源。 / blockquote>

-

驱动器C：错误。 （A）bort（R）etry（S）mack The Darned Thing

Say I have a Windows 2000 server running Terminal Services with a single
file Access DB (not front end/back end) on it, could multiple users access
the data base simultaneously?
Paul

解决方案

Paul H wrote:

Say I have a Windows 2000 server running Terminal Services with a
single file Access DB (not front end/back end) on it, could multiple
users access the data base simultaneously?
Paul

They could do so exactly as they could if Terminal Services was not involved.
Meaning that it can be done, but it would not be recommended unless they app
were split with each user getting a separate copy of the front end.

--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

What of databases were multiple users were in, but not utilizing the
same objects?

One of the current backlashes we''re getting from our IT group is that
MS is specifically saying that Access draws too much resources from the
memory pool.

There are several answers to this.... Mostly having to do with how the
Access program is programmed, and what technologies are used within
the Access database.

Generally speaking, the utility that most IT people use to monitor
memory usage doesn''t _accurately_ reflect that Access uses a _very_
low priority memory thread that Access will gladly give up to just
about any process that wants more memory. In other words, the
reporting tool is reporting incomplete information. ("100% usage!
Man, that Access is a hog!" What they don''t see is that the priority
of that usage is so low that moving the mouse causes Access to release
that memory.)

The above said however, there are also programming methods that can
indeed really "hog" a system. Opening and closing a form a bunch of
times for example, or failure to set objects to nothing and assuming
that Access will clean up after you, can indeed have a significant
drain on system resources.

There are a number of articles in the Knowledge base that address this
issue, and it can become quite complex.

On 28 Sep 2005 13:43:26 -0700, "ac*******@railvan.com"
<ac*******@railvan.com> wrote:

One of the current backlashes we''re getting from our IT group is that
MS is specifically saying that Access draws too much resources from the
memory pool.

--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

这篇关于可以通过终端服务使用多用户Access数据库吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！