Connection String Question

[JDog]

Hi,

I have an Excel addin that uses an ADODB.connection object to connect to an Access 2007 database that resides on a network drive.

The connection string I am using is here:
cnFMDB.Open "Provider = Microsoft.ACE.OLEDB.12.0;Data Source = " & strFMDB

where cnFMDB is my connection object and strFMDB is the location of my database.

My question is that unless I close this connection object I cannot make changes to my access database. It give me an error message saying that another user has the file open. Can I modify my connection string so that I can still modify the database?

Thanks.

 

[Galaxiom]

You really wouldn't want to be modyfying the database structure while there is an active connection to it.