VBA远程串行验证 [英] VBA remote serial validation
问题描述
大家好，
我有一个访问数据库，我想与用户分享进行测试。我想要实现的功能如下。这是否可以使用Access？
1.首次运行db user会显示输入serial的表单。串行保存在本地表中以便连续打开。
2. db检查互联网连接。
3.如果互联网连接，输入的串行连接是根据远程网络可访问的值进行检查MySQL数据库。
4.如果找到serial，db打开。如果没有找到，db关闭。
5.如果没有互联网连接，db将串行存储在本地表中并增加一个数字字段，只允许三次打开而不验证远程序列。
看起来像是一段相当标准的代码，但我似乎无法找到一个现有的解决方案，我可以根据自己的需求量身定制。
右边的任何推动方向，所以我可以开始研究如何完成这项工作将非常感激。
感谢所有！
Hi guys,
I have an access db that I want to share with users for testing. The functionality I would like to implement is below. Is this possible with Access?
1. first run of db user is presented with form to enter serial. Serial is saved in local table for successive opens.
2. db checks for internet connection.
3. if internet connection, serial entered is checked against values in remote web accessible MySQL database.
4. if serial is found, db opens. If not found, db closes.
5. if no internet connection, db stores serial in local table and increments a numeric field allowing only three opens without validating remote serial.
Seems like a fairly standard piece of code but I can''t seem to find an existing solution that I can tailor to fit my needs.
Any nudges in the right direction so I can begin to research how to get this done would be most appreciated.
Thanks to all!
推荐答案
你还没有真正弄清楚这个Tux中的序列是什么或者指的是什么，但除此之外它已经过深思熟虑了。这是迈出的第一步。我建议下一步是开始编码并查看卡住的地方。然后我们可以提供帮助。但是在这个阶段并没有太多问题。
You haven''t really made clear what a serial is or refers to in this Tux, but otherwise it''s been well thought through. That''s the first step done. I would suggest the next step is to start coding it and seeing where you get stuck. Then we may be able to assist. There''s not really much of a question at this stage though.
使用你的方案，我所要做的就是减少你的验证，减少表中的计数器。
With your scheme, all I have to do to get around your validation is decrement the counter in the table.
这篇关于VBA远程串行验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
