Error accessing file. Network connection may be lost

[Dan01]

I'm trying to run a function that uses DAO to open an object of the database the code resides in:
Dim myDB As Database
Dim rst, rstTable As Recordset


Set myDB= OpenDatabase("G:\dept\share\My.mdb&quot
Set rst = myDB.OpenRecordset("qryOutput", dbOpenForwardOnly)
Set rstTable = myDB.OpenRecordset("tblOutput&quot

When trying to run I get the error in the subject field. Code worked earlier today. Please advise. Thanks, Dan.

 

[annsolomon]

This could be a number of things. If by any chance, you're running Norton AntiVirus, turn off the scripting option. Ann

 

[Dan01]

Thanks Ann. Actually the problem is described in Microsoft Knowledge Base Article 304548 - ACC2000: Error Message: Error Accessing File. Network Connection May Have Been Lost.
The fix is a patch from Microsoft. Dan.

 

[annsolomon]

I had seen it before. But, my advice about Norton holds true also for this error message.

Glad you found your fix. Ann