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?