Thanks. I have read this FAQ and I think that I can distribute and develop with MSDE 2000.

This was my first solution, but when I needed to execute some DDL with the same DMO connection I got an error.

I haven't EM or QA. I'm coding with MSDE. I use some free applications like DbaMGR and SQL Server NameSpace Explorer.

I can, with DdbMGR or Access, connect to the database...

My last solution don't work either. I have to find another and I code this:

Private Sub DatabaseLock()

On Error GoTo ErrDatabaseLock

bDatabaseLocked = False

...

quote:

---

If the first attempt to put it in single user succeeds, the second one will result in a trappable error.

---

quote:

---

Single user mode should do that. Can you post some code?

Andy

http://www.sqlservercentral.com/columnists/awarren/

---

Dim c1 As...