ADO -2147467259 error, but only after going to 'Design View'?

[Megabyte]

Hi,

My setup: ADO connection using adUseClient for the cursor location. Database is *not* split.


I have a button (lets call it test) that connects to a database, and sends a simple query “selects * from myTable”, then closes the connection. I can click on this button as many times as I want without
error or issues.


The problem: The moment I switch my form to ‘Design View’ and back to ‘Form’ view I will receive error: -2147467259 (database placed in locked state by me).


I can fix this by: Closing the form and reopening it in form View.



I can even fix this by: Opening any table (even one Im not quering) and closing that table


Thoughts?

[ranman256]

sounds like the ado connect still has a lock open.

[Megabyte]

Interesting theory, but I just ran a test that ruled that one:

1# I opened the form (without clicking on ADO, or connecting to anything ADO related)
2# Changing to Design view
3# Changing back to form view
4# Clicking on the ADO test button for the first time andgetting the same error.

It’s like the act of going into design view changes something. The moment I open up the database it makes a ‘laccdb’ file, but I'm still able to connect with ADO without issue (tested both select and insert). Seems everything works 100% fine, and only breaks once I enterdesign view then back into form view.