pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Access 2000 and ODBC driver
2+ messages / 1 participants
[nested] [flat]

* Access 2000 and ODBC driver
@ 2000-07-10 21:45 Michael Möhle <mmoehle@nikocity.de>
  2000-07-11 06:55 ` Re: Access 2000 and ODBC driver Michael Möhle <mmoehle@nikocity.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Michael Möhle @ 2000-07-10 21:45 UTC (permalink / raw)
  To: pgsql-interfaces

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 !

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Access 2000 and ODBC driver
  2000-07-10 21:45 Access 2000 and ODBC driver Michael Möhle <mmoehle@nikocity.de>
@ 2000-07-11 06:55 ` Michael Möhle <mmoehle@nikocity.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Möhle @ 2000-07-11 06:55 UTC (permalink / raw)
  To: pgsql-interfaces

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 !

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2000-07-11 06:55 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-07-10 21:45 Access 2000 and ODBC driver Michael Möhle <mmoehle@nikocity.de>
2000-07-11 06:55 ` Michael Möhle <mmoehle@nikocity.de>

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