Thread: 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 !
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 NikolaidisTo: Michael MöhleSent: Tuesday, July 11, 2000 5:25 AMSubject: Re: [INTERFACES] Access 2000 and ODBC driverI'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öhleSent: Monday, July 10, 2000 5:45 PMSubject: [INTERFACES] Access 2000 and ODBC driverHello,I have writen an application with ms-access 2000 as frontend for postgres. Normally it works well, but each timewhen i have openend a form in my frontend and im doing nothing for some time (the pc goes into powersaving) i can'twork 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-deland 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.5options in Postgres ODBC :driver:KSQO enabledRecognize unique indexes enabledText as LonVarChar enabledrest disabledConnection:Row Versioning enabledrest disabledThanks for your help !