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?