I have a VFP 6.0 application linking to an Access 97 table with multiple remote views using the same connection. Sometimes it works, other times I get a 1541 Connection "name" is Busy error.

I looked up Microsoft KB http://support.microsoft.com/support/kb/articles/Q191/3/43.ASP and tried resolution #2 (of sort) creating a second connection in my data environment and linking the remote view I get the error on to the new ODBC connection.

I still get the error.

I get the error on a Replace command with a For Clause.

Any suggestions or pointers.

Thank you. Chris Hansen, CAI Inc. Tallahassee FL.
hans@nettally.com

p.s., this is my first use of the Thread, thank you.