>I have an Access 97 database. I has IIS4 on a NT4 box. I have created a dynamic query tool to produce real-time reports using data from the Access 97 database. However, when the report tries and runs, the system returns the following error:
>
>[State=S1000][Error=-1032][Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine connot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
>
>I have looked up the error code for the jet engine and they start at -2032 and go ot -3185. -1032 is not in there. Second, the section about the unknown file bothers me, but I can't find any other explaination for it. I have also checked the ODBC documentation and it did not help.
>
>Finally, I have tried all kinds of security settings (user names and passwords) and still can not work around this error!
>
>Can anybody help?

Are you using ADO, ODBC, ???
Can you provide a sample of the connection code to the database?

Usually when I get this error there is something wrong with my connection string.

Michael