After I justed the swap space on our server’s C drive from 384MB to 128MB. The jet engine on the server started giving errors like those below. How can I effectively troubleshoot this?
*********************************************
[Microsoft][ODBC Text Driver] The Microsoft Jet database engine cannot open the file ‘(unknown)’. It is already opened exclusively by another user, or you need permission to view its data.
The following error occurred:
[Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed
*********************************************
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file
‘(unknown)’. It is already opened exclusively by another user, or you need permission to view its data.