a2k从关闭中获得多用户权限 [英] a2k getting multi-user right from the off
问题描述
我觉得我在这里有很好的学习机会。我被要求
敲打一个简单的数据库来管理房间和大厅的租赁。我对这个设计很有信心，但是想要让它成为多用户，即使它现在并不是绝对必要的。
虽然我已经阅读了多次在这里列出的正确的
网站，但我没有太多的经验，直到关于不是的提示
使用域名聚合功能来提高性能（诚然，
让我感到困惑，因为我没有看到我如何在没有它们的情况下得到它，但是我
离题）。
我有三个问题，一个与上面相关的一般问题和两个
具体，
首先，如果你想开发一个简单的多用户数据库，那么什么
基本提示会给谁？我估计这个会使用乐观的
锁定，并且一次不会被超过10个人使用，并且
在大多数情况下可能只有2个。 />
我可以将什么东西设计到我的应用程序中（以及我的应用程序中除外）
以后的悲伤？
其次，如果我正在发布一个仅限运行时版本并将前后端分成
，用户如何（没有访问权限）
控制安全性？我认为我必须设计一个表单并使用VBA来支持
允许他们访问用户和密码？在这种情况下，我猜
工作组安全文件将在带有表的服务器上？
最后有哪些提示可以在网络上进行测试？在
域vs p2p模型上工作会对Access的工作方式产生任何影响吗？
感谢
Deano（多用户noobie）
Deano写道：
即使我读过，我也没有多少经验这里列出了多次正确的网站，关于不使用域聚合功能提高性能的提示（不可否认，这让我感到困惑，因为我看不到我怎么做没有他们，但我离题了。
本世纪我还没有使用过域聚合函数。他们过去常常很慢，或者至少这是我的回忆，当然是因为我放弃了它们，无论是好还是坏。但是我相信这已经发生了变化，现在它们已经非常令人满意了？
Lyle Fairfield写道：
Deano写道：
我没有多少经验，即使我已经阅读了多次在此列出的正确网站，关于
不使用域聚合功能来提高性能的提示
（诚然，这让我感到困惑，因为我没有看到如果没有它们我怎么能得到，但我离题了。） / blockquote>
本世纪我还没有使用过Domain Aggregate Function。他们使用
来缓慢，或者至少这是我的回忆，当然是我抛弃它们的原因，无论好坏。但是我相信它已经改变了，现在它们已经非常令人满意了吗？
我很想听听别人对此的看法，因为他们是非常方便，
在报告中，我可以用它们来计算总数和
使用它们与即时IF语句来检查空值等。
查看Trevor Best并查看他对域名功能的替换是否会产生很大的影响。使用来自（也许）Randy Birch的
网站VBNet的GetTickCount，尽管它的名字是VB6，*不是* VB.NET。
然后测试和自行决定。在网络上测试时应该证明一个非常方便的功能
。其他一些有用的东西在彼得
沃格尔的书，Visual Basic对象和组件手册，你可以在这里阅读
：
http://www.amazon.com/exec/obidos/AS...406578-8650243
他的代码可以让你测试你申请中的各种东西
所以你知道在哪里寻找问题。
Hi,
I feel I have a good learning opportunity here. I have been asked to
knock up a simple db for managing lettings of rooms and halls. I''m
confident about the design but want to make it multi-user even though
it''s not strictly necessary right now.
I''ve not much experience in this even though i''ve read the correct
websites that have been listed here many times, down to tips about not
using domain aggregrate functions to improve performance (admittedly
that confuses me as I don''t see how I could get by without them, but I
digress).
I do have three questions, one general related to the above and two
specific,
First, if you do want to develop a simple multi-user database, what
basic tips would anyone give? I reckon this one will use optimistic
locking and won''t be used by more than 10 people at a time, and
probably just 2 in most cases.
What things could I design into (and out of) my app that will save me
grief later on?
Secondly, if I''m distributing a runtime only version and have split
into front and back-ends, how do the users (who don''t have Access)
control security? I presume I have to design a form and use VBA to
allow them access to users and passwords? In this scenario I guess the
workgroup security file would be on the server with the tables?
Finally what tips are there for testing on networks? Does working on a
domain vs p2p model make any difference in how Access works?
thanks
Deano (multi-user noobie)解决方案Deano wrote:
I''ve not much experience in this even though i''ve read the correct
websites that have been listed here many times, down to tips about not
using domain aggregrate functions to improve performance (admittedly
that confuses me as I don''t see how I could get by without them, but I
digress).
I haven''t used a Domain Aggregate Function in this century. They used to
be SLOW, or at least that is my recollection and certainly the reason,
good or bad, that I abandoned them; but I believe that has changed and
that they are quite satisfactorily speedy now?
Lyle Fairfield wrote:
Deano wrote:
I''ve not much experience in this even though i''ve read the correct
websites that have been listed here many times, down to tips about
not using domain aggregrate functions to improve performance
(admittedly that confuses me as I don''t see how I could get by
without them, but I digress).
I haven''t used a Domain Aggregate Function in this century. They used
to be SLOW, or at least that is my recollection and certainly the
reason, good or bad, that I abandoned them; but I believe that has
changed and that they are quite satisfactorily speedy now?
Well i''d love to hear from people about this because they are so handy,
not least of all in reports where I can use them to count totals and
use them with immediate IF statements to check for nulls etc.
Check with Trevor Best and see if his replacements for domain functions
make a large difference. Use GetTickCount from (maybe) Randy Birch''s
website VBNet, which in spite of its name is for VB6, *not* VB.NET.
Then test and decide for yourself. Should prove a very handy function
when testing on a network. Some other helpful stuff is in Peter
Vogel''s book, Visual Basic Object and Component Handbook, which you can
read about here:
http://www.amazon.com/exec/obidos/AS...406578-8650243
He has code that allows you to test various things in your application
so you know where to look for problems.
这篇关于a2k从关闭中获得多用户权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
