ADO Connection String

[Hoodwink]

Is there a parameter that can be set in an ADO connection string that
will not lock the MDB for Exclusive use?

I have one MDB that must connect to another MDB to update data
periodically. The second MDB is used as a source for an ASP page. An
error occurs when the first MDB tries to initiate an ADO connection to
the second MDB when the web server is processing an internet request
involving that page.

 

[Douglas J. Steele]

Somehow I doubt it's the connection string: you actually have to specify
something specific in order to make the connection exclusive (see what Carl
Prothman has at http://www.able-consulting.com/ado_conn.htm for samples)

It's more likely that the security context under which one or the other
connections is running doesn't have the appropriate permissions on the
folder where the MDB file exists. All users require Change access (Read,
Write, eXecute, Delete) to ensure problems such as this don't occur.