I have 5 recordsets on a page that use the same connection file to
connect to various tables in an access mbd via the usual include file
procedure:

**********

<!--#include file="../Connections/connMydb.asp" -->

Set....
recordset1.ActiveConnection = MM_connMydb_STRING

Set......
recordset2.ActiveConnection = MM_connMydb_STRING

etc

**********

I did have to comment out the 'dim MM_connMydb_STRING' in the file
connMydb.asp which has always worked just fine until this week when on one
server I started to get

the '80004005 unspecified error ' or 'file in use error' on the
Activeconnection line.

there seems to be a permissions issue here but it has been suggested that I need to recode either the multiple recordset pages I use or the connection file.

How do you get round this potential problem