Screen Freeze-up

[cdacey]

WE HAVE SETUP AN ACCESS DATABASE ON A SMALL PEER-TO-PEER LOCAL-AREA-NETWORK WITH A SERVER AND ONE REMOTE WORKSTATION. WE HAVE BEEN HAVING A CONSISTANT PROBLEM WITH THE SYSTEM FREEZING WHEN THE USER ON THE SERVER CLICKS ON A PARTICULAR FORM. THE ONLY WAY TO GET OUT OF IT IS TO CONTROL-ALT-DELETE AND RESTART THE ENTIRE SYSTEM. THE DATABASE HAS NEVER FROZEN LIKE THIS ON THE STAND-ALONE PC WE BUILT IT ON AFTER HUNDREDS OF HOURS OF TESTING. ALSO, WHEN WE FIRST INSTALLED THE PROGRAM ON THE SERVER, WE NOTICED THAT THE DEFAULT DATE FIELD VALUES (=DATE()) DID NOT APPEAR AND A #NAME? APPEARED INSTEAD. WE SOLVED THIS PART OF THE PROBLEM BY LOADING A RUN-TIME VERSION OF THE PROGRAM, WHICH MUST HAVE INSTALLED NEEDED SYSTEM FILES AND THE DEFAULT DATES APPEARED. BUT WE ARE STILL HAVING THIS SYSTEM FREEZING PROBLEM.

ANY THOUGHTS ON WHERE THE PROBLEM MIGHT LIE ??

THANKS CHRIS

 

[mission2java_78]

STOP YELLING AT ME .

Try splitting the db into a front end and a back end.

Jon

 

[cdacey]

Thansk,
Sorry for the Caps. But we had already split the database, same problem. Any other thoughts ??
Thanks

 

[tpk]

I had experience form freeze up when I use the echo off and forgot to turn it on. But your case may be different, because mine is only need to close the MS Access but do not need to reset the computer.

 

[cdacey]

TPK,

I actually mistated that, we only needed to cont-alt-delete to end the process and close the program. Could you elaborate on "echo off" ??
Thanks Chris

 

[tpk]

Hi,
In the VBA, I put cammand "DoCmd.Echo False", the purpose is to run some command but not to update the screen (To freeze the screen). After finished all the command, we should turn it on by using "DoCmd.Echo True", if not the screen will be hang and have to use CTRL-ALT-DEL to end the task (close MS Access).

Hope can help you.