Access和Postgresql [英] Access and Postgresql
问题描述
我有一个我在Access 2003中构建的应用程序。它是一个电子医疗
记录程序分为前端（8台计算机）和后端。
这个运行完美无缺。购买了一个使用Postgresql的计费程序。
它与我们的Access后端位于同一台计算机上。
我们不断被淘汰出新的计费程序而且永远不会受到打击<我的Access程序中有
。计费软件提供商说在同一台机器上运行的Access和
Postgresql导致了这个问题。
有没有人听说过这个，因为我们离不开Access程序。
我不太了解Postgresql，任何帮助都将不胜感激。
Pete
- -
通过 http://www.accessmonster.com
I have an application I built in Access 2003. It is an electronic medical
records program split into front end (8 computers) and back end.
This runs flawlessly. Purchased a billing program that uses Postgresql.
This resides on the same computer as our Access backend.
We keep getting knocked out of the new billing program and never get knocked
out of my Access program. The billing software provider says that Access and
Postgresql running on the same machine is causing the problem.
Has anyone ever heard of this as we cannot go without the Access program.
I don''t know much about Postgresql and any help will be appreciated.
Pete
--
Message posted via http://www.accessmonster.com
推荐答案
此软件提供商是否了解Access仅在
服务器上运行托管支持的文件？ Access后端只是一个
文件共享，所以我不知道它会如何影响Postgresql或任何其他SQL
服务器，除非你重载服务器。
访问运行时应用程序存在于相当多的系统中。 MS Office将为某些功能安装
。如果提供商无法给您更好的解释，您可能需要重新考虑计费软件。
" jptpjs via AccessMonster.com" < u14870 @ uwewrote in message
news：709b5f7dfb67e @ uwe ...
Does this software provider understand that Access is Not running on a
server that is only hosting the backed file? The Access backend is only a
file share, so I don''t see how it could affect Postgresql or any other SQL
server, unless you are overloading the server.
Access runtime application exist on quite a few system. MS Office will
install it for certain features. If the provider cannot give you a better
explanation, you may need to reconsider you billing software.
"jptpjs via AccessMonster.com" <u14870@uwewrote in message
news:709b5f7dfb67e@uwe...
我有一个我在Access 2003中构建的应用程序。它是一个电子医疗
记录程序分为前端（8台计算机）和后端。
运行完美无缺。购买了使用Postgresql的计费程序。
这与我们的Access后端位于同一台计算机上。
我们不断被淘汰出新的计费程序，永远不会获得
I have an application I built in Access 2003. It is an electronic medical
records program split into front end (8 computers) and back end.
This runs flawlessly. Purchased a billing program that uses Postgresql.
This resides on the same computer as our Access backend.
We keep getting knocked out of the new billing program and never get
敲了
knocked
我的Access程序。计费软件提供商说Access
out of my Access program. The billing software provider says that Access
和
and
在同一台机器上运行的Postgresql导致问题。
有没有人听说过这个，因为我们不能没有Access程序。
我不太了解Postgresql，任何帮助将不胜感激。
Pete
-
留言通过 http://www.accessmonster.com
" jptpjs通过AccessMonster.com < u14870 @ uwewrote
"jptpjs via AccessMonster.com" <u14870@uwewrote
我有一个我在Access 2003中构建的应用程序。它是一个
电子病历程序分成前端
（8台电脑）和后端。这完美运行。
购买了一个使用Postgresql的计费程序。
它与我们的Access
后端位于同一台计算机上。我们不断被淘汰新的
计费程序，永远不会被我的
访问计划淘汰。计费软件提供商说
在同一台机器上运行的Access和Postgresql
导致问题。
有没有人听说过这个我们不能没有
的Access程序。
我不太了解Postgresql和任何帮助
将不胜感激。
I have an application I built in Access 2003. It is an
electronic medical records program split into front end
(8 computers) and back end. This runs flawlessly.
Purchased a billing program that uses Postgresql.
This resides on the same computer as our Access
backend. We keep getting knocked out of the new
billing program and never get knocked out of my
Access program. The billing software provider says
that Access and Postgresql running on the same machine
is causing the problem.
Has anyone ever heard of this as we cannot go without
the Access program.
I don''t know much about Postgresql and any help
will be appreciated.
如果您在服务器上有一个拆分的Access数据库，其中包含后端（表，数据和
关系） -end（查询，表单，报告，
宏和模块）在用户的机器上运行，就像你应该的那样，并且你看起来好像是b
，然后我就你的计费软件了解了一些情况
提供商：他们对Access的了解很少，他们自己在公共场合犯了傻瓜，因为他们指责它不可能是__执行。
访问不在同一台机器上运行，因为Jet是一个文件服务器
数据库，只能访问后端它将访问本地计算机上的
文件。在Access / Jet拆分数据库配置中，
Access在用户的本地计算机上执行所有操作。 （事实上，
就是这种情况，即使前端没有拆分，或者两个
前端和后端都保存在服务器，除非你是通过使用Windows终端服务或
Citrix MetaFrame故意在服务器上执行的，但是，即便如此，也不会有干扰与<另外，PostgreSQL是一个服可以通过在用户的
机器上运行的前端访问。但是，即使前端是在Access中创建的，两个
应用程序也不会互相干扰。
所以，事实是它们是_hoping_这是其他一些软件干扰
所以他们不必调查，调试和纠正他们的软件。现在，
有可能其他一些软件可能会干扰（虽然不是很可能是b $ b）但是，如果是这样的话，它不是Access也不是Jet。
您可能会建议他们在尝试
$ b $之前，如果他们了解其他数据库的话，他们可以避免在公共场合再次愚弄自己的傻瓜
b责怪那些其他数据库。
Larry Linson
Microsoft Access MVP
If you have a split Access database with back-end (tables, data, and
relationships) on the server, and the front-end (queries, forms, reports,
macros, and modules) running on the user''s machines, as you should, and as
it appears you do, then I know something about your billing software
provider: they know so little about Access that they have made fools of
themselves in public by blaming it for something it _could not_ be doing.
Access is NOT running on the same machine, because Jet is a file-server
database, and only accesses the back-end in the same way it would access a
file on the local machine. In the Access/Jet split database configuration,
Access does all its execution on the user''s local machine. (And, in fact,
that would be the case, even if the front end were not split, or if both the
front end and back end were saved on the server, UNLESS you were
deliberately executing on the server by using Windows Terminal Services or
Citrix MetaFrame. And, even so, there would be no "interference" with
PostgreSQL.)
PostgreSQL, on the other hand, is a server database and it executes on the
server, though it may be accessed via a front end that runs on the user''s
machine. But, even if that front-end were created in Access, the two
applications would not interfere with one another.
So, the fact is they are _hoping_ that it is some other software interfering
so they won''t have to investigate, debug, and correct their software. Now,
it IS possible that some other software could be interfering (though not
very likely), but, if so, it is not Access nor Jet.
You might suggest they can avoid making fools of themselves in public again
in the future if they learn something about other databases before trying to
blame those other databases.
Larry Linson
Microsoft Access MVP
谢谢Larry，
一些附加信息是Access正在运行前端，后面
在托管Postgresql程序的同一台机器上运行。
一个其他计算机运行相同的计费程序与上面提到的相同机器上的数据。
供应商说我们应该只尝试运行计费软件而不是
访问emr一段时间以查看它是否不会导致用户失败。
问题是在没有任何警告的情况下被淘汰那么谁知道我们将不得不检查
。
只是为了让你知道EMR永远不会有问题。
Pete
Larry Linson写道：
Thanks Larry,
Some added information is that Access is running the front end and the back
end on the same machine that is hosting the Postgresql program.
One other computer is running the same billing program with the data on the
same machine mentioned above.
Vendor says we should try only running the billing software without or the
Access emr for a while to see if it does not knock users out.
Problem is getting knocked out occurs without any warning so who knows how
long we would have to check.
Just to let you know the EMR never, ever has issues.
Pete
Larry Linson wrote:
我有一个我建的应用程序在Access 2003.它是一个
电子病历程序分为前端
I have an application I built in Access 2003. It is an
electronic medical records program split into front end
[引用文字剪辑 - 10行]
[quoted text clipped - 10 lines]
我不太了解Postgresql和任何帮助
将不胜感激。
I don''t know much about Postgresql and any help
will be appreciated.
如果您在服务器和前端（查询，表单，报告）上有一个拆分的Access数据库，其中包含后端（表，数据和
关系） ，就像你应该的那样在用户的机器上运行，
宏和模块，然后就像你看到的那样，那么我对你的计费软件供应商有所了解：他们知道关于Access的一点点关于他们自己在公共场合犯了傻瓜的事情，指责它不能做什么。
访问不在同一台机器上运行，因为Jet是一个文件-server
数据库，只能以与访问本地计算机上的
文件相同的方式访问后端。在Access / Jet拆分数据库配置中，Access会在用户的本地计算机上执行所有操作。 （事实上，即使前端没有拆分，或者前端和后端都保存在服务器上，情况也是如此，除非你是
故意在服务器上使用Windows终端服务或Citrix MetaFrame执行。即使如此，也不会对PostgreSQL产生干扰。）
PostgreSQL，另一方面，它是一个服务器数据库，它在服务器上执行，但它可以通过在用户机器上运行的前端访问。但是，即使这个前端是在Access中创建的，这两个应用程序也不会相互干扰。
所以，事实是他们正在希望它是其他一些软件干扰
所以他们不必调查，调试和纠正他们的软件。现在，
有可能其他一些软件可能会干扰（虽然不太可能），但是，如果是这样，它就不是Access也不是Jet。
你可能会建议如果他们在尝试指责其他数据库之前了解其他数据库，他们可以避免再次公开愚弄自己。
Larry Linson
Microsoft Access MVP
If you have a split Access database with back-end (tables, data, and
relationships) on the server, and the front-end (queries, forms, reports,
macros, and modules) running on the user''s machines, as you should, and as
it appears you do, then I know something about your billing software
provider: they know so little about Access that they have made fools of
themselves in public by blaming it for something it _could not_ be doing.
Access is NOT running on the same machine, because Jet is a file-server
database, and only accesses the back-end in the same way it would access a
file on the local machine. In the Access/Jet split database configuration,
Access does all its execution on the user''s local machine. (And, in fact,
that would be the case, even if the front end were not split, or if both the
front end and back end were saved on the server, UNLESS you were
deliberately executing on the server by using Windows Terminal Services or
Citrix MetaFrame. And, even so, there would be no "interference" with
PostgreSQL.)
PostgreSQL, on the other hand, is a server database and it executes on the
server, though it may be accessed via a front end that runs on the user''s
machine. But, even if that front-end were created in Access, the two
applications would not interfere with one another.
So, the fact is they are _hoping_ that it is some other software interfering
so they won''t have to investigate, debug, and correct their software. Now,
it IS possible that some other software could be interfering (though not
very likely), but, if so, it is not Access nor Jet.
You might suggest they can avoid making fools of themselves in public again
in the future if they learn something about other databases before trying to
blame those other databases.
Larry Linson
Microsoft Access MVP
-
通过 http://www.accessmonster.com
--
Message posted via http://www.accessmonster.com
这篇关于Access和Postgresql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
