Muliti User App-如何通知用户要求 [英] Muliti User App - How to notify a user a reqest has been made

问题描述

嗨
我使用VB 2011 Express做一个小型的库存控制应用程序(Windows窗体应用程序-链接到Access数据库).公司中有很多用户，他们需要互相请求和接收库存.我猜想这个应用程序很适合用于基于Web的用户界面和真实的数据库(SQL或类似数据库)，但是我的编码经验仅限于VB和Windows窗体，因此决定以我对此一无所知的方式进行开发.为了使问题简短，一个例子是:

1)用户A要求库存.
2)将所请求库存的详细信息写到表中，状态为已请求"
3)用户B的应用程序轮询数据库以查找该表中状态为已请求"的项目
4)如果发现要求的内容，请在用户B的界面上显示内容
5)用户B发出库存，物料状态更改为已发送"
5)用户A接受库存，状态更改为已接受"

我担心的是:
1)Access如何处理几个不同的用户对数据库进行轮询(也许每秒一次?)
2)如果两个应用尝试同时查询同一张表，其中一个查询会崩溃吗?

我想知道是否存在一种简单的方法来使每个用户PC上加载的应用程序通过公司网络彼此直接通信，是否还有其他更优雅的方式来实现这种类型的交互? >
任何意见或想法都将受到欢迎！

谢谢

R

解决方案

Access，SQL和其他数据库旨在支持多个用户，因此网络上有几个用户轮询数据库应该没有问题. /blockquote>

Hi
Im doing a small application for stock control using VB 2011 Express (Windows forms application - linked to an Access Database). There are a handfull of users in the company, who need to request and receive stock from one another. I guess this app would lend itself to a web based user interface, and a real database (SQL or similar) but my coding experience is pretty limited to VB and windows forms so decided to go with what little I know about that. To try to keep the question short, one example would be:

1) User A requests stock.
2) Write details of requested stock to a table, with status ''Requested''
3) User B''s app polls the database looking for items in that table with status ''Requested''
4) If it finds something requested, display something on User B''s interface
5) User B issues the stock, and the status of the item is changed to ''Sent''
5) User A accepts the stock, and the status is changed to ''Accepted''

My concerns are:
1)How will Access handle a few different users polling the database (Maybe once a second?)
2) If two apps try to query the same table at the same time, will one of the queries crash?

I was wondering if there is a simple way for the applications loaded on each users PC''s to communicate directly with one another over the company network, of if there was any other more elegant way of achieving this type of interaction?

Any comments or ideas would be welcomed!

Thanks

R

解决方案

Access, SQL, and other databases are designed to support multiple users so there should be no issues with having a few users on the network polling the db.

这篇关于Muliti User App-如何通知用户要求的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！