ADO .Open problem (posted on general news too)

[Paul Finey]

Hi Jack
The problem is because you have the database open, I
suggest that you close the database and try again, or you
could try opening the database in "shared" mode. Check
the default opening mode
under "Tools";"Options";"Advanced" and select "Shared"

HTH
Paul