From: Michael Möhle <mmoehle@nikocity.de>
To: interfaces postgres <pgsql-interfaces@postgresql.org>
Subject: Re: Access 2000 and ODBC driver
Date: Tue, 11 Jul 2000 08:55:32 +0200
Message-ID: <002401bfeb05$04f21100$0a19a8c0@mbd.de> (raw)
References: <000801bfeab8$31029c80$0a19a8c0@mbd.de>
<003301bfeae7$a04fea00$6401a8c0@byron>
I think I have found the problem. Its no problem with only one PC. I 've got the problem with about 20 PC and all other applications come back from power saving. No the problem is in ACCESS 2000.The default for ODBC refresh time in A2000 ist 32766 sec! The refresh time for A2000 Tables is 60 sec. Changed the ODBC time to the same value and everything works fine (I hope). Thanks for your help!
Michael
----- Original Message -----
From: Byron Nikolaidis
To: Michael Möhle
Sent: Tuesday, July 11, 2000 5:25 AM
Subject: Re: [INTERFACES] Access 2000 and ODBC driver
I've seen problems with power saving that have nothing to do with Postgres or Access. I was playing a game, PC went into power save after 30 minutes, I came back and could not resume.
Byron
----- Original Message -----
From: Michael Möhle
To: pgsql-interfaces@postgresql.org
Sent: Monday, July 10, 2000 5:45 PM
Subject: [INTERFACES] Access 2000 and ODBC driver
Hello,
I have writen an application with ms-access 2000 as frontend for postgres. Normally it works well, but each time
when i have openend a form in my frontend and im doing nothing for some time (the pc goes into powersaving) i can't
work again with my form. I can't close it, i can't go to the next record --nothing. The only thing i can do is press ctrl-alt-del
and then kill the access-task.
What the hell is it?
My configuration is:
- Access 2000 (with .mbd or mde version of my frontend)
- Postgres 7.0.2
-ODBC driver 6.500
-MDAC 2.5
options in Postgres ODBC :
driver:
KSQO enabled
Recognize unique indexes enabled
Text as LonVarChar enabled
rest disabled
Connection:
Row Versioning enabled
rest disabled
Thanks for your help !
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: mmoehle@nikocity.de
Subject: Re: Access 2000 and ODBC driver
In-Reply-To: <002401bfeb05$04f21100$0a19a8c0@mbd.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox