Received: from smtp1.nikoma.de (smtp1.nikoma.de [212.122.128.19]) by hub.org (8.10.1/8.10.1) with ESMTP id e6B6jqW94768 for ; Tue, 11 Jul 2000 02:45:52 -0400 (EDT) Received: from michael (dialin161.pg11.hamburg.nikoma.de [213.54.50.161]) by smtp1.nikoma.de (8.9.3/8.9.3) with SMTP id IAA19925 for ; Tue, 11 Jul 2000 08:45:50 +0200 (CEST) (envelope-from mmoehle@nikocity.de) Message-ID: <002401bfeb05$04f21100$0a19a8c0@mbd.de> From: =?iso-8859-1?Q?Michael_M=F6hle?= To: "interfaces postgres" References: <000801bfeab8$31029c80$0a19a8c0@mbd.de> <003301bfeae7$a04fea00$6401a8c0@byron> Subject: Re: Access 2000 and ODBC driver Date: Tue, 11 Jul 2000 08:55:32 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0021_01BFEB15.C5352BE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Archive-Number: 200007/61 This is a multi-part message in MIME format. ------=_NextPart_000_0021_01BFEB15.C5352BE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I think I have found the problem. Its no problem with only one PC. I 've go= t the problem with about 20 PC and all other applications come back from po= wer saving. No the problem is in ACCESS 2000.The default for ODBC refresh t= ime in A2000 ist 32766 sec! The refresh time for A2000 Tables is 60 sec. Ch= anged the ODBC time to the same value and everything works fine (I hope). T= hanks for your help! Michael ----- Original Message -----=20 From: Byron Nikolaidis=20 To: Michael M=F6hle=20 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 Postgre= s or Access. I was playing a game, PC went into power save after 30 minut= es, I came back and could not resume.=20 Byron ----- Original Message -----=20 From: Michael M=F6hle=20 To: pgsql-interfaces@postgresql.org=20 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 postgr= es. 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 recor= d --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 =20=20=20=20=20 rest disabled Connection: Row Versioning enabled rest disabled Thanks for your help ! ------=_NextPart_000_0021_01BFEB15.C5352BE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I think I have found the problem. Its no p= roblem=20 with only one PC. I 've got the problem with about 20 PC and all other=20 applications come back from power saving. No the problem is in ACCESS 2000.= The=20 default for ODBC refresh time in A2000 ist 32766 sec! The refresh time for = A2000=20 Tables is 60 sec. Changed the ODBC time to the same value and everything wo= rks=20 fine (I hope). Thanks for your help!
Michael
----- Original Message -----
Fro= m:=20 Byron Nikolaidis
Sent: Tuesday, July 11, 2000 5:25= =20 AM
Subject: Re: [INTERFACES] Access 2= 000 and=20 ODBC driver

I've seen problems with power saving tha= t have=20 nothing to do with Postgres or Access.   I was playing a game, = PC=20 went into power save after 30 minutes, I came back and could not=20 resume. 
Byron
----- Original Message -----
F= rom:=20 Mich= ael=20 M=F6hle
To: pgsql-interfaces@postgresql.org= =20
Sent: Monday, July 10, 2000 5:45= =20 PM
Subject: [INTERFACES] Access 200= 0 and=20 ODBC driver

Hello,
I have writen an application with ms-a= ccess=20 2000 as frontend for postgres. Normally it works well, but each=20 time
when i have openend a form in my front= end and=20 im doing nothing for some time (the pc goes into powersaving) i=20 can't
work again with my form. I can't close= it, i=20 can't go to the next record --nothing. The only thing i can do is press= =20 ctrl-alt-del
and then kill the access-task.<= /DIV>
What the hell is it?
My configuration is:
 
- Access 2000 (with .mbd or mde versio= n of my=20 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 !
 
------=_NextPart_000_0021_01BFEB15.C5352BE0--