对多用户系统使用Access [英] Using Access for a multi user system
问题描述
我是Access的新手，并被要求开发一个简单的Access系统
来替换已经存在的系统。
当前Access系统有五个用户，每个用户在本地机器上处理
系统的副本。
我想将我的新系统开发为多用户系统，并将其放在服务器上，以便每个用户远程访问。我有
读取MS Access中的锁定可能是地狱般的。我读过的大部分
文章都是关于互联网应用程序写成的.asp文章，这些文章有超过五个用户。我希望
能够保持可维护性以便集中存储我的系统，但是
将使MS Access能够处理我的五个用户点击数据库
并发？值得注意的是，没有两个用户可以编辑相同的记录。
提前感谢您的帮助
MM
Hi,
I''m new to Access and have been asked to develop a simple Access system
to replace one that already exists. There are five users of the
current Access system and each of the users works off a copy of the
system on their local machines.
I would like to develop my new system as a multi-user system and place
it on a server to be accessed remotely by each of the users. I have
read that the locking in MS Access can be hellish. Most of the
articles I''ve read however have been .asp articles that were written
about internet applications that would have more than five users. I
would love for maintainability etc to store my system centrally but
will MS Access be able to handle my five users hitting the database
concurrently? It could be worth noting that no two users would ever be
editing the same record.
Thanks in advance for your help
MM
推荐答案
Luvin lunch写道：
Luvin lunch wrote:
$ b $
我是Access的新手，并被要求开发一个简单的Access
系统来替换已经存在的系统。当前的Access系统有五个用户是
，每个用户在本地机器上处理系统的副本
。
我想将我的新系统开发为多用户系统，并将其放在服务器上，以便每个用户远程访问。我有
读取MS Access中的锁定可能是地狱般的。我读过的大部分
文章都是关于互联网应用程序写成的.asp文章，这些文章有超过五个用户。我希望
能够保持可维护性以便集中存储我的系统，但是
将使MS Access能够处理我的五个用户点击数据库
并发？值得注意的是，没有两个用户可以编辑相同的记录。
提前感谢您的帮助
MM
Hi,
I''m new to Access and have been asked to develop a simple Access
system to replace one that already exists. There are five users of
the current Access system and each of the users works off a copy of
the system on their local machines.
I would like to develop my new system as a multi-user system and place
it on a server to be accessed remotely by each of the users. I have
read that the locking in MS Access can be hellish. Most of the
articles I''ve read however have been .asp articles that were written
about internet applications that would have more than five users. I
would love for maintainability etc to store my system centrally but
will MS Access be able to handle my five users hitting the database
concurrently? It could be worth noting that no two users would ever
be editing the same record.
Thanks in advance for your help
MM
这是个坏主意，但不是因为你说的原因。通过网络使用
相同文件的多个用户显着增加了文件损坏的可能性。在服务器上共享数据文件的分割设计和每个用户拥有自己的前端文件本地副本的
被认为是处理多个用户的正确方法应用程序。
位于中心位置的单个文件实际上很难维护，因为你需要在进行更改时将所有用户踢出去。使用拆分设计
这不是问题，并且设置一个系统来自动推送更新
给用户没什么大不了的。
-
Rick Brandt，Microsoft Access MVP
电子邮件（视情况而定）至...
在Hunter dot的RBrandt com
It''s a bad idea, but not for the reason you stated. Multiple users using
the same file over a network significantly increases the chances of file
corruption. A split design where the data file is shared on a server and
each user has their own local copy of the front end file is considered the
proper way to handle multiple user applications.
The centrally located "single file" is actually harder to maintain because
you have to kick all users out while you make changes. With a split design
this is not an issue and setting up a system to automatically push updates
to the users is no big deal.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
" Luvin lunch" < ma ************ @ o2.iewrote留言
news：11 ****************** ****@i42g2000cwa.googlegr oups.com ...
"Luvin lunch" <ma************@o2.iewrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...
我是新来的访问并被要求开发一个简单的Access系统
来替换已经存在的系统。
当前Access系统有五个用户，每个用户在本地机器上处理
系统的副本。
我想将我的新系统开发为多用户系统，并将其放在服务器上，以便每个用户远程访问。我有
读取MS Access中的锁定可能是地狱般的。我读过的大部分
文章都是关于互联网应用程序写成的.asp文章，这些文章有超过五个用户。我希望
能够保持可维护性以便集中存储我的系统，但是
将使MS Access能够处理我的五个用户点击数据库
并发？值得注意的是，没有两个用户可以编辑相同的记录。
Hi,
I''m new to Access and have been asked to develop a simple Access system
to replace one that already exists. There are five users of the
current Access system and each of the users works off a copy of the
system on their local machines.
I would like to develop my new system as a multi-user system and place
it on a server to be accessed remotely by each of the users. I have
read that the locking in MS Access can be hellish. Most of the
articles I''ve read however have been .asp articles that were written
about internet applications that would have more than five users. I
would love for maintainability etc to store my system centrally but
will MS Access be able to handle my five users hitting the database
concurrently? It could be worth noting that no two users would ever be
editing the same record.
Access将在睡眠状态下处理您的需求。我强烈建议您分割数据库并为每个用户提供他们自己的
本地前端副本。如果您对此概念不熟悉，请搜索
" split database"的帮助。不要试图在服务器上只提供一个文件，
这种配置被广泛怀疑是造成数据损坏的原因。
腐败。
祝你的项目好运。
基思。
www.keithwilby.com
为了确保多用户设置的稳定性，您可以阅读我的文章，了解如何制作
这项工作相当不错。特别是如果你只有5个用户..
我解释你如何在这里设置它：
http://www.members.shaw.ca/AlbertKal...plit/index.htm
For stability in a multi-user setup, you can read my article on how to make
this work quite well. Especially if you only have 5 users..
I explain how you can set this up here:
http://www.members.shaw.ca/AlbertKal...plit/index.htm
>写成
的文章
>articles that were written
关于互联网应用
哦，我的......你是在谈论在你本地网络上工作的几个用户
（局域网），还是你在谈论用户远程使用系统？ />
互联网？如果您正在谈论互联网，那么您可以阅读以下文章中的
，并且我提供了一些您可以考虑用于
远程用户的解决方案，并使用ms-访问itnternet ....
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
pl*****************@msn.com
about internet applications
Oh, my...are you talking about a few users at work on you local network
(LAN), or are you talking about users remotely using the system over the
internet? If you are talking about the internet, then you can read the
following article of mine, and I offer some solutions you can consider for
remote users, and using ms-access OVER the itnternet....
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
这篇关于对多用户系统使用Access的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
