ADO Connection Puts Network Database In Read Only

[schwimms]

Hi All,

I have an excel spreadsheet that is linked into an access database through ADO connections. The spreadsheet is set up to make updates and adds directly into a table in my database. The database is on a server, what is happening is, and I don't know the cause, the database is being put into read only mode and gets stuck in read only. There is no record locking database file that is getting created as well, which is usually what happens when you open a database.

The connections when contacting the database are set to:

Conn1.Mode = adModeReadWrite

and when it is done with either the update or add the connection is closed:

Conn1.Close
Conn1.ConnectionString = ""

Does anyone know how I can avoid my database getting locked up? Or is this jsut a server issue that may be causing it? Is there a way to avoid the server from causing this issue?

[sparbag]

Hello,

Destroy the connection object

conn1 = Nothing

kind regards

steve