[AccessD] Recordset Open

Just a quick guess does the table have at least one index and are you
using an updateable cursor

Elam, Debbie wrote:

>I am trying to open a table on a SQL server using an ADO recordset.  I get
>an error that the operation is not allowed when the object is open.  No help
>files come up with help so no pointers there.  
>
>I have other tables opening using virtually identical recordsets out of the
>same database with no problems.  This database is exclusively used by me
>right now, though that should not be an issue.  I have discovered that I
>will not get the error if I open it as a query on that table that returns no
>records. (not helpful to me obviously).
>
>If anyone has any ideas about where the issue might be, help is appreciated
>and needed urgently.
>
>Debbie
>- JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1) subject
>to the Attorney-Client Privilege, (2) an attorney work product, or (3)
>strictly confidential. If you are not the intended recipient of this
>message, you may not disclose, print, copy or disseminate this information.
>If you have received this in error, please reply and notify the sender
>(only) and delete the message. Unauthorized interception of this e-mail is a
>violation of federal criminal law. 
>This communication does not reflect an intention by the sender or the
>sender's client or principal to conduct a transaction or make any agreement
>by electronic means.  Nothing contained in this message or in any attachment
>shall satisfy the requirements for a writing, and nothing contained herein
>shall constitute a contract or electronic signature under the Electronic
>Signatures in Global and National Commerce Act, any version of the Uniform
>Electronic Transactions Act or any other statute governing electronic
>transactions.
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada