Hello Everybody, I have a Back E

[CHTHOMAS]

Hello Everybody,

I have a Back End which performs some calculations in every 25 seconds. The front end tables are linked to the Backend. Both the front end and Back end lies on the Network. The front end table links to the Back end are refreshed once in every 20 seconds. My problems....

1) when a user opens the fron end and if it is during the time during which the back end perfroms the calculations, the user gets a "reserved error 1601 or 3034" Messages (i believe to my best that is why the error message appears). I tried changing the duration of calculations. But no good.

2) If it is the time during which the fron end tables are linked, the user gets an error message saying "can't find the input table or query" error.

My questions.

1) Is there any way that the back end can flag to the fron end that the processing is taking place and allow the front end to access the data once the processing in the back end is finished.

2) Within the fron end itself when the table links are being refreshed is there any way to wait.

I developed the db, put it on the network for users on trial basis and the result is incrediable... a series of error messages.

Any ideas, suggestions or solutions on how to tackle both or any of the problem will be highly appreciated.

Regards and Thanks

Charley

 

[PaulF]

Here's a shot in the dark...
On the form that opens when you open the mdb
Place an error handler in the Form's On Open Event

Trap for error numbers 1601 and 3034


Private Sub Form_Open(Cancel As Integer)
Exit Sub
ErrHandlerOnOpen:
If err.Number = 1601 or err.Number = 3034 Then
Resume
Else
MsgBox err.Number & " : " & err.Description,vbCritical,"UnExpected Error"
End if
End Sub


Like I said, just a shot in the dark.... I don't have a system running like that where I can test it.
PaulF

 

[Rohdem]

Why do you need to refresh the links every 20 seconds? Can't you just refresh the data?

Mike Rohde
rohdem@marshallengines.com