Re: Access and Postgresql

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:
I have an application I built in Access 2003. It is an
electronic medical records program split into front end
[quoted text clipped - 10 lines]
I don't know much about Postgresql and any help
will be appreciated.

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

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Python Database Apps
    ... make an app that has a local DB and a server side DB. ... It maybe overkill for a client side database. ... The psycopg package makes interfacing to PostgreSQL very easy and there is a package for Linux and Windows to make cross-platform development a breeze. ... If an app comes already designed for mysql, oracle, sqlite, db2, dbm, ...
    (comp.lang.python)
  • Re: Re: help choosing OLAP solutions that run on/with pgsql
    ... > for MSTR ... > Application server if need be. ... > and the underlying database itself. ... > Using a combination of PostGreSQL for the warehouse and Jasper ...
    (comp.databases.olap)
  • Re: [PHP] warning message to hide
    ... PostgreSQL database, my code displays the following error message: ... Unable to connect to PostgreSQL server: could not connect to server: ... I would like instead of that, to display my own error message... ...
    (php.general)
  • Re: Access and Postgresql
    ... Purchased a billing program that uses Postgresql. ... If you have a split Access database with back-end (tables, data, and ... relationships) on the server, and the front-end (queries, forms, reports, ...
    (comp.databases.ms-access)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)