I am having problems querying a access database that is on another pc
that I have a mapped drive to. I have full access to that drive, the
privileges on that share are for everyone with full control. The folder
and the file are the same way. As soon as I put the mdb on my machine it
works fine. I have tried updating MDAC and turning off let IIS control
passwords in the Directory Security option under properties in Management
Console. The error message is:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[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.
/intranettest/pcdevelopment/requestforservices/customerrequests.asp, line
22
I have tried OLE DB connections, DSN-less connections and File DSN and
pretty much all error messages say the same. The database file can be
opened by anyone.
Help
Patrick