I am getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
I am assuming that I am somehow opening the .MDB exclusively but I can't find where (or I'm wrong :) ).
Checked the DSN in ODBC manager and it is not set to exclusive.
This is how I'm opening it:
set conn = createobject("adodb.connection")
conn.connectionstring="Provider=MSDASQL.1;Persist Security Info=False;Data Source=Test"