problem with my connection ODBC to a MS Access 2000

Having a problem with my connection hanging. ODBC to a MS Access 2000 db.

I have a sub-form, which retrieves data from the db. After I open the connection, I have a lock file (.idb) the entire time the form is open. I close the recordset and connection immediately after I get the data. But as I said, the lock file is not deleted until I unload the sub-form.



Thanks in advance for any help.



I have a number of users using the program on a server and occasionally a user is blocked with the following error message. I assume this is due to the connection not clearing.



“Run-time error'-2147467259(80004005) (Microsoft) (ODBC Microsoft Access Driver) could not use'(Unknown)'; file already in useâ€

If your just reading data you should change your connection string so that it will not exclusively lock the db. You can get example conn strings here: http://www.connectionstrings.com/