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 -----
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 -----
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 !