ADO + open

Hi,

I have an application which runs at 2 sites.
1 site is perfect.
On the second one:
Inside the application I open a previously saved recordset as so:
rs.open "FileName", Nothing, adLockReadOnly, adOpenStatic

It works fine sometimes and sometimes gives me error 3709 -
The connection cannot be used to perform this opeartion. It is either closed or invalid in this context.

Remember, it works most of the times.

Any ideas?

You say on a previosly saved recordset.

I think the connection is closed sometimes.

If it isn't u get no errors else you do.
Where you have Nothing in the open statement of the rs you should place a opened connection.

You can't open a saved recordset to a file with a valid connection because it then expects a sql statement.

What is your goal with this recordset.
What is it used for ?
Does it has to be saved to the Db or is it for temporary use ?

The use of this recordset is irrelevant.
The issue is that I occasionally get a 3709 error on only 1 machine while trying to open it with a Nothing or Blank as a connection.

Any ideas?