Re: Access - can't close Form

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 ODBC Update 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 will be 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(at)rdg-rational(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly