Re: Access - can't close Form - Mailing list pgsql-general

From Fabrizio Mazzoni
Subject Re: Access - can't close Form
Date
Msg-id 20030929192506.248a46f8.veramente@libero.it
Whole thread Raw
In response to Access - can't close Form  ("E. Zorn (RDG-rational) postsql" <postsql@rdg-rational.de>)
List pgsql-general
Hi .. i have the same problem ..

If i left forms open i would get the same error and could not close them unless i would change to design mode ..

and solved it this way :

In the access db open the database then in the menu open Tools --> Options Then go in then Advanced section and set the
ODBCUpdate interval to 32766 (instead of 1500) 

Next run regedit on the windows machine that opens the db and go to the following key:

HKLM --> Software --> Microsoft --> Jet --> 4.0 --> ODBC and change the following key : (If you use access 97 than jet
willbe 3.5 and not 4.0) 

Connection Timeout from 600 to 0 (Remember to use decimal and not hexadecimal when you edit)


It took me about 5 motnhs to understand this problem but finally it worked!!!

Best Regards,

Fabrizio Mazzoni
Macron Srl


On Mon, 29 Sep 2003 17:34:22 +0200
"E. Zorn (RDG-rational) postsql" <postsql@rdg-rational.de> wrote:

>
> Hi,
> i use Access as a frontend via ODBC to an Linux-based postgresql.
>
> I have a problem in a form where I use a lot of subforms. In some
> cases ( i couldn't detect when - but I really try to) the form and Access
> hangs.
>
> The only way to close the form is to close Access via "cross" (upper right
> corner).
> If I try then to view once again the form I get the following error message:
> "Sie konnen diese Aktion momentan nicht ausfuhren" means : "You counldn't do
> this now".
>
> Has anybody an idea - why this is hanging or where i can start to debug.
>
> -Elmar
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: RT with PostgreSQL .
Next
From: Tom Lane
Date:
Subject: Re: numeric rounding