MS Access 2007 - network interruption issue

[shsh_shah]

I have an ms access application where i have front end and back end ... When i try to run a command on a specific form i get

" your network was interupted .To continue close and then open again "

I have front and backend running on same machine and in the same folder. I have a link manager button which basically link all tables to the front end.

Basically i am closing off the stock at the end of every month so here is the code that is in use:

Private Sub Command5_Click()
On Error GoTo Err_Command5_Click

Dim stDocName As String

stDocName = "Cl Closing 2 Opening Qry"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_Command5_Click:
Exit Sub

Err_Command5_Click:
MsgBox Err.Description
Resume Exit_Command5_Click



End Sub

And in the main form i added following:

Dim dbsAlwaysOpen As DAO.Database

Private Sub Form_Close()
Set dbsAlwaysOpen = Nothing
End Sub

Private Sub Form_Open(Cancel As Integer)
Set dbsAlwaysOpen = OpenDatabase("H:\EnglishBiscuit\English Biscuits.mdb", False)
End Sub

Any help please?

[RuralGuy]

Is this form *in* the "English Biscuits.mdb"? There is no reason for this code if it is. What do you mean "I have a link manager button which basically link all tables to the front end."

[shsh_shah]

Is this form *in* the "English Biscuits.mdb"? There is no reason for this code if it is. What do you mean "I have a link manager button which basically link all tables to the front end."

It suppose to run a query because it is Docmd.OpenQuery

I just mentioned the link thing for kind of no reason just to mention here that if my db location is changed so i just link the application to it.

Private Sub Command19_Click()
On Error GoTo Err_Command19_Click

    Dim stDocName As String

    stDocName = "Macro1"
    DoCmd.RunMacro stDocName

Exit_Command19_Click:
    Exit Sub

Err_Command19_Click:
    MsgBox Err.Description
    Resume Exit_Command19_Click
    
End Sub

Also i am running Access on Vista. Please help

[RuralGuy]

You still have that code in the Open and Close events of the form that could cause the problem you described.

[shsh_shah]

You still have that code in the Open and Close events of the form that could cause the problem you described.

thanks , I removed it but still the same error.

[RuralGuy]

It may be a Vista issue which I can't help with. Can you try it on a different OS or do you want to post the db and I'll try it on XP?