[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use

I got this when trying to open a second recordset in an ASP page. The problem was the permission on the directory where the database was didn't allow the IUSR_.. user to create or modify files, even though they could modify the mdb file. Presumably it was something to do with access to the .ldb file.