问题描述
我已经在商店里琢磨了一段时间的想法，如果有其他人有兴趣的话，我很好。
我正在考虑为Access MDB创建服务器实现。
这是一个相当直接的想法。服务器将是一个程序
，它会监听SQL命令，例如发送给它的SELECT或INSERT（通过TCP / IP）。反过来，它将针对
本地数据库运行SQL并返回记录（用于SELECT）或执行
信息（用于INSERT，UPDATE，DELETE）。 />
我认为我还可以实现虚拟
客户端上的记录集对象，可以进行检索，允许您编辑，转换为
UPDATE SQL，然后将其重新发送回服务器。这可以让你用相当容易和透明的对象工作
。
我还没有建造它，但我正在考虑它。还有其他人
可以用它吗？我知道我在某种程度上重塑了一个真正的
数据库，但在很多情况下，Access可以通过更多的连接来扩展它的实用性（和希望有更多的抗腐蚀性。
因为我是那些顽固的Access家伙之一，我知道我想要它是b $ b。
有什么想法吗？
-Ben
I''ve been tossing around an idea here in the shop for a while, and I am
curious if anyone else out there would be interested.
I am thinking of creating a server implementation for Access MDBs.
It''s a fairly straight-forward idea. The server would be a program
that would listen for SQL commands, such as SELECTs or INSERTs to be
sent to it (over TCP/IP). In turn, it would run the SQL against the
local database and return either records (for SELECT) or execution
information (for INSERT, UPDATE, DELETE).
I think that I could also implement a "virtual" recordset object on the
client end, which would retreive, allow you to edit, translate to
UPDATE SQL, and fire it back to the server. This would let you work
with the object fairly easily and transparently.
I haven''t built it yet, but I am thinking about it. Would anybody else
get any use out of it? I know that I am somewhat reinventing a "real"
database, but in many cases, Access could extend it''s usefulness with a
bit more connectivity (and hopefully a bit more corruption-resistance).
Since I''m one of those die-hard Access guys, I know that I would like
it.
Any thoughts?
-Ben
推荐答案
过去曾经发布过这个ng（wolfsomethingorother）的其他人告诉我们使用VB6建立一个使用VB6的Jet数据库的中间件tcp / ip链接。
。那时候没有多少兴奋。
Someone else who used to post to this ng (wolfsomethingorother) told of
building a middle ware tcp/ip link to a Jet database using VB6. Didn''t
raise to much excitement back then.
这篇关于有人想要一个Access Server吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！